Overview
Brought to you by YData
Dataset statistics
| Number of variables | 44 |
|---|---|
| Number of observations | 5860 |
| Missing cells | 12839 |
| Missing cells (%) | 5.0% |
| Duplicate rows | 11 |
| Duplicate rows (%) | 0.2% |
| Total size in memory | 9.1 MiB |
| Average record size in memory | 1.6 KiB |
Variable types
| Numeric | 13 |
|---|---|
| Categorical | 21 |
| Text | 7 |
| DateTime | 1 |
| Boolean | 1 |
| Unsupported | 1 |
Category has constant value "Default" | Constant |
Shipping Address Country has constant value "IN" | Constant |
Billing Address Country has constant value "IN" | Constant |
Shipping Method has constant value "STD" | Constant |
Gift Wrap has constant value "False" | Constant |
HSN Code has constant value "62045300.0" | Constant |
GST Tax Type Code has constant value "GST12" | Constant |
UTGST has constant value "0" | Constant |
CESS has constant value "0" | Constant |
UTGST Rate has constant value "0" | Constant |
CESS Rate has constant value "0" | Constant |
Sale Order Status has constant value "COMPLETE" | Constant |
GSTIN has constant value "09AAICN9819MIZL" | Constant |
| Dataset has 11 (0.2%) duplicate rows | Duplicates |
Billing Address Id is highly overall correlated with Shipping Address Id | High correlation |
Billing Address Pincode is highly overall correlated with Billing Address State and 5 other fields | High correlation |
Billing Address State is highly overall correlated with Billing Address Pincode and 5 other fields | High correlation |
CGST is highly overall correlated with CGST Rate and 4 other fields | High correlation |
CGST Rate is highly overall correlated with Billing Address Pincode and 8 other fields | High correlation |
Channel Name is highly overall correlated with Discount and 3 other fields | High correlation |
Discount is highly overall correlated with Channel Name and 1 other fields | High correlation |
IGST is highly overall correlated with CGST and 8 other fields | High correlation |
IGST Rate is highly overall correlated with Billing Address Pincode and 9 other fields | High correlation |
Item Type Color is highly overall correlated with IGST and 3 other fields | High correlation |
MRP is highly overall correlated with IGST and 5 other fields | High correlation |
Prepaid Amount is highly overall correlated with Channel Name | High correlation |
SGST is highly overall correlated with CGST and 4 other fields | High correlation |
SGST Rate is highly overall correlated with Billing Address Pincode and 8 other fields | High correlation |
Selling Price is highly overall correlated with IGST and 4 other fields | High correlation |
Shipping Address Id is highly overall correlated with Billing Address Id | High correlation |
Shipping Address Pincode is highly overall correlated with Billing Address Pincode and 5 other fields | High correlation |
Shipping Address State is highly overall correlated with Billing Address Pincode and 5 other fields | High correlation |
Shipping Courier Status is highly overall correlated with Shipping Tracking Status | High correlation |
Shipping Tracking Status is highly overall correlated with Channel Name and 1 other fields | High correlation |
Subtotal is highly overall correlated with Channel Name and 4 other fields | High correlation |
Total Price is highly overall correlated with IGST and 4 other fields | High correlation |
CGST Rate is highly imbalanced (60.0%) | Imbalance |
IGST Rate is highly imbalanced (59.7%) | Imbalance |
SGST Rate is highly imbalanced (60.0%) | Imbalance |
Shipping Courier Status is highly imbalanced (74.0%) | Imbalance |
Item Type Color has 4961 (84.7%) missing values | Missing |
MRP has 188 (3.2%) missing values | Missing |
Cost Price has 5860 (100.0%) missing values | Missing |
GST Tax Type Code has 1591 (27.2%) missing values | Missing |
Shipping Courier Status has 98 (1.7%) missing values | Missing |
Shipping Tracking Status has 98 (1.7%) missing values | Missing |
Cost Price is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Prepaid Amount has 5195 (88.7%) zeros | Zeros |
Discount has 1176 (20.1%) zeros | Zeros |
CGST has 4926 (84.1%) zeros | Zeros |
IGST has 934 (15.9%) zeros | Zeros |
SGST has 4926 (84.1%) zeros | Zeros |
Reproduction
| Analysis started | 2025-03-01 10:33:59.680903 |
|---|---|
| Analysis finished | 2025-03-01 10:34:43.810154 |
| Duration | 44.13 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
Shipping Address Id
Real number (ℝ)
High correlation 
| Distinct | 5680 |
|---|---|
| Distinct (%) | 96.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19079918 |
| Minimum | 17037893 |
|---|---|
| Maximum | 20951988 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 45.9 KiB |
Quantile statistics
| Minimum | 17037893 |
|---|---|
| 5-th percentile | 17307195 |
| Q1 | 18267788 |
| median | 18918412 |
| Q3 | 20102973 |
| 95-th percentile | 20824217 |
| Maximum | 20951988 |
| Range | 3914095 |
| Interquartile range (IQR) | 1835185 |
Descriptive statistics
| Standard deviation | 1091279.9 |
|---|---|
| Coefficient of variation (CV) | 0.05719521 |
| Kurtosis | -1.0743422 |
| Mean | 19079918 |
| Median Absolute Deviation (MAD) | 810727 |
| Skewness | 0.11659087 |
| Sum | 1.1180832 × 1011 |
| Variance | 1.1908919 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 18030566 | 5 | 0.1% |
| 17147660 | 4 | 0.1% |
| 18634020 | 4 | 0.1% |
| 18260913 | 4 | 0.1% |
| 18603959 | 4 | 0.1% |
| 18259525 | 4 | 0.1% |
| 18409077 | 3 | 0.1% |
| 18317699 | 3 | 0.1% |
| 18504225 | 3 | 0.1% |
| 18277293 | 3 | 0.1% |
| Other values (5670) | 5823 |
| Value | Count | Frequency (%) |
| 17037893 | 1 | |
| 17038427 | 1 | |
| 17039694 | 1 | |
| 17048514 | 1 | |
| 17052967 | 1 | |
| 17055540 | 1 | |
| 17057290 | 1 | |
| 17058666 | 1 | |
| 17058904 | 1 | |
| 17059345 | 1 |
| Value | Count | Frequency (%) |
| 20951988 | 1 | |
| 20950770 | 1 | |
| 20949763 | 1 | |
| 20949385 | 1 | |
| 20949182 | 1 | |
| 20948869 | 1 | |
| 20948572 | 1 | |
| 20948430 | 1 | |
| 20948416 | 1 | |
| 20948258 | 1 |
Category
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.4 KiB |
| Default |
|---|
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Default |
|---|---|
| 2nd row | Default |
| 3rd row | Default |
| 4th row | Default |
| 5th row | Default |
Common Values
| Value | Count | Frequency (%) |
| Default | 5860 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| default | 5860 |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 5860 | |
| e | 5860 | |
| f | 5860 | |
| a | 5860 | |
| u | 5860 | |
| l | 5860 | |
| t | 5860 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 35160 | |
| Uppercase Letter | 5860 | 14.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 5860 | |
| f | 5860 | |
| a | 5860 | |
| u | 5860 | |
| l | 5860 | |
| t | 5860 |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 5860 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 41020 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| D | 5860 | |
| e | 5860 | |
| f | 5860 | |
| a | 5860 | |
| u | 5860 | |
| l | 5860 | |
| t | 5860 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 41020 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| D | 5860 | |
| e | 5860 | |
| f | 5860 | |
| a | 5860 | |
| u | 5860 | |
| l | 5860 | |
| t | 5860 |
Invoice Code
Text
| Distinct | 5680 |
|---|---|
| Distinct (%) | 96.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 414.4 KiB |
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 15.387201 |
| Min length | 13 |
Unique
| Unique | 5525 ? |
|---|---|
| Unique (%) | 94.3% |
Sample
| 1st row | NIMAT25F01090 |
|---|---|
| 2nd row | NIMAT25F01091 |
| 3rd row | NIMAT25F01092 |
| 4th row | I0925NC000006459 |
| 5th row | I0925NC000006454 |
| Value | Count | Frequency (%) |
| i0925nc000004025 | 5 | 0.1% |
| i0925nc000005015 | 4 | 0.1% |
| i0925nc000004335 | 4 | 0.1% |
| i0925nc000004990 | 4 | 0.1% |
| i0925nc000004333 | 4 | 0.1% |
| i0925nc000003225 | 4 | 0.1% |
| i0925nc000004247 | 3 | 0.1% |
| i0925nc000005149 | 3 | 0.1% |
| nimat25f00854 | 3 | 0.1% |
| nimat25f00163 | 3 | 0.1% |
| Other values (5670) | 5823 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 31769 | |
| 5 | 8687 | 9.6% |
| 2 | 7702 | 8.5% |
| 9 | 6377 | 7.1% |
| I | 5860 | 6.5% |
| N | 5860 | 6.5% |
| C | 4663 | 5.2% |
| 4 | 2825 | 3.1% |
| 6 | 2763 | 3.1% |
| 3 | 2536 | 2.8% |
| Other values (7) | 11127 | 12.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 68998 | |
| Uppercase Letter | 21171 | 23.5% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 31769 | |
| 5 | 8687 | 12.6% |
| 2 | 7702 | 11.2% |
| 9 | 6377 | 9.2% |
| 4 | 2825 | 4.1% |
| 6 | 2763 | 4.0% |
| 3 | 2536 | 3.7% |
| 7 | 2507 | 3.6% |
| 1 | 2138 | 3.1% |
| 8 | 1694 | 2.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 5860 | |
| N | 5860 | |
| C | 4663 | |
| M | 1197 | 5.7% |
| A | 1197 | 5.7% |
| T | 1197 | 5.7% |
| F | 1197 | 5.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 68998 | |
| Latin | 21171 | 23.5% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 31769 | |
| 5 | 8687 | 12.6% |
| 2 | 7702 | 11.2% |
| 9 | 6377 | 9.2% |
| 4 | 2825 | 4.1% |
| 6 | 2763 | 4.0% |
| 3 | 2536 | 3.7% |
| 7 | 2507 | 3.6% |
| 1 | 2138 | 3.1% |
| 8 | 1694 | 2.5% |
Latin
| Value | Count | Frequency (%) |
| I | 5860 | |
| N | 5860 | |
| C | 4663 | |
| M | 1197 | 5.7% |
| A | 1197 | 5.7% |
| T | 1197 | 5.7% |
| F | 1197 | 5.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 90169 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 31769 | |
| 5 | 8687 | 9.6% |
| 2 | 7702 | 8.5% |
| 9 | 6377 | 7.1% |
| I | 5860 | 6.5% |
| N | 5860 | 6.5% |
| C | 4663 | 5.2% |
| 4 | 2825 | 3.1% |
| 6 | 2763 | 3.1% |
| 3 | 2536 | 2.8% |
| Other values (7) | 11127 | 12.3% |
Invoice Created
Date
| Distinct | 392 |
|---|---|
| Distinct (%) | 6.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 45.9 KiB |
| Minimum | 2024-01-10 09:59:00 |
|---|---|
| Maximum | 2025-12-02 10:48:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
| Distinct | 955 |
|---|---|
| Distinct (%) | 16.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 370.7 KiB |
Length
| Max length | 21 |
|---|---|
| Median length | 18 |
| Mean length | 7.7609215 |
| Min length | 3 |
Unique
| Unique | 442 ? |
|---|---|
| Unique (%) | 7.5% |
Sample
| 1st row | Raebareli |
|---|---|
| 2nd row | Phagwara |
| 3rd row | Berhampore |
| 4th row | Hyderabad |
| 5th row | Kolkata |
| Value | Count | Frequency (%) |
| delhi | 495 | 7.4% |
| new | 330 | 4.9% |
| mumbai | 330 | 4.9% |
| bangalore | 280 | 4.2% |
| pune | 200 | 3.0% |
| gurgaon | 181 | 2.7% |
| noida | 157 | 2.4% |
| hyderabad | 147 | 2.2% |
| nagar | 122 | 1.8% |
| bengaluru | 118 | 1.8% |
| Other values (918) | 4308 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 8240 | |
| r | 3437 | 7.6% |
| u | 2777 | 6.1% |
| i | 2597 | 5.7% |
| e | 2552 | 5.6% |
| n | 2411 | 5.3% |
| h | 2306 | 5.1% |
| d | 1916 | 4.2% |
| l | 1841 | 4.0% |
| o | 1640 | 3.6% |
| Other values (46) | 15762 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 37624 | |
| Uppercase Letter | 6869 | 15.1% |
| Space Separator | 879 | 1.9% |
| Other Punctuation | 74 | 0.2% |
| Open Punctuation | 10 | < 0.1% |
| Close Punctuation | 10 | < 0.1% |
| Decimal Number | 8 | < 0.1% |
| Dash Punctuation | 5 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 8240 | |
| r | 3437 | |
| u | 2777 | 7.4% |
| i | 2597 | 6.9% |
| e | 2552 | 6.8% |
| n | 2411 | 6.4% |
| h | 2306 | 6.1% |
| d | 1916 | 5.1% |
| l | 1841 | 4.9% |
| o | 1640 | 4.4% |
| Other values (15) | 7907 |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 915 | |
| N | 800 | |
| G | 686 | |
| D | 627 | |
| M | 565 | 8.2% |
| P | 430 | 6.3% |
| A | 393 | 5.7% |
| K | 383 | 5.6% |
| J | 304 | 4.4% |
| S | 282 | 4.1% |
| Other values (14) | 1484 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 4 | |
| 4 | 4 |
Space Separator
| Value | Count | Frequency (%) |
| 879 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 74 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 10 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 10 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 44493 | |
| Common | 986 | 2.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 8240 | |
| r | 3437 | 7.7% |
| u | 2777 | 6.2% |
| i | 2597 | 5.8% |
| e | 2552 | 5.7% |
| n | 2411 | 5.4% |
| h | 2306 | 5.2% |
| d | 1916 | 4.3% |
| l | 1841 | 4.1% |
| o | 1640 | 3.7% |
| Other values (39) | 14776 |
Common
| Value | Count | Frequency (%) |
| 879 | ||
| , | 74 | 7.5% |
| ( | 10 | 1.0% |
| ) | 10 | 1.0% |
| - | 5 | 0.5% |
| 2 | 4 | 0.4% |
| 4 | 4 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 45479 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 8240 | |
| r | 3437 | 7.6% |
| u | 2777 | 6.1% |
| i | 2597 | 5.7% |
| e | 2552 | 5.6% |
| n | 2411 | 5.3% |
| h | 2306 | 5.1% |
| d | 1916 | 4.2% |
| l | 1841 | 4.0% |
| o | 1640 | 3.6% |
| Other values (46) | 15762 |
Shipping Address State
Categorical
High correlation 
| Distinct | 35 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 380.8 KiB |
| Uttar Pradesh | |
|---|---|
| Maharashtra | |
| Delhi | |
| Karnataka | |
| Haryana | |
| Other values (30) |
Length
| Max length | 40 |
|---|---|
| Median length | 17 |
| Mean length | 9.5187713 |
| Min length | 3 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Uttar Pradesh |
|---|---|
| 2nd row | Punjab |
| 3rd row | West Bengal |
| 4th row | Telangana |
| 5th row | West Bengal |
Common Values
| Value | Count | Frequency (%) |
| Uttar Pradesh | 935 | |
| Maharashtra | 830 | |
| Delhi | 495 | |
| Karnataka | 482 | 8.2% |
| Haryana | 470 | 8.0% |
| Madhya Pradesh | 340 | 5.8% |
| Gujarat | 310 | 5.3% |
| Rajasthan | 281 | 4.8% |
| Bihar | 273 | 4.7% |
| West Bengal | 215 | 3.7% |
| Other values (25) | 1229 |
Length
| Value | Count | Frequency (%) |
| pradesh | 1390 | |
| uttar | 935 | |
| maharashtra | 830 | |
| delhi | 495 | 6.4% |
| karnataka | 482 | 6.3% |
| haryana | 470 | 6.1% |
| madhya | 340 | 4.4% |
| gujarat | 310 | 4.0% |
| rajasthan | 281 | 3.7% |
| bihar | 273 | 3.6% |
| Other values (36) | 1877 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 13859 | |
| r | 6081 | |
| h | 5410 | 9.7% |
| t | 4332 | 7.8% |
| s | 3148 | 5.6% |
| e | 2550 | 4.6% |
| n | 2281 | 4.1% |
| d | 2280 | 4.1% |
| 1823 | 3.3% | |
| P | 1533 | 2.7% |
| Other values (32) | 12483 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 46277 | |
| Uppercase Letter | 7631 | 13.7% |
| Space Separator | 1823 | 3.3% |
| Other Punctuation | 49 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 13859 | |
| r | 6081 | |
| h | 5410 | 11.7% |
| t | 4332 | 9.4% |
| s | 3148 | 6.8% |
| e | 2550 | 5.5% |
| n | 2281 | 4.9% |
| d | 2280 | 4.9% |
| i | 1235 | 2.7% |
| l | 1093 | 2.4% |
| Other values (12) | 4008 | 8.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 1533 | |
| M | 1176 | |
| U | 1005 | |
| K | 577 | 7.6% |
| D | 502 | 6.6% |
| H | 499 | 6.5% |
| B | 488 | 6.4% |
| G | 338 | 4.4% |
| T | 297 | 3.9% |
| R | 281 | 3.7% |
| Other values (8) | 935 |
Space Separator
| Value | Count | Frequency (%) |
| 1823 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 49 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 53908 | |
| Common | 1872 | 3.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 13859 | |
| r | 6081 | |
| h | 5410 | 10.0% |
| t | 4332 | 8.0% |
| s | 3148 | 5.8% |
| e | 2550 | 4.7% |
| n | 2281 | 4.2% |
| d | 2280 | 4.2% |
| P | 1533 | 2.8% |
| i | 1235 | 2.3% |
| Other values (30) | 11199 |
Common
| Value | Count | Frequency (%) |
| 1823 | ||
| & | 49 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 55780 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 13859 | |
| r | 6081 | |
| h | 5410 | 9.7% |
| t | 4332 | 7.8% |
| s | 3148 | 5.6% |
| e | 2550 | 4.6% |
| n | 2281 | 4.1% |
| d | 2280 | 4.1% |
| 1823 | 3.3% | |
| P | 1533 | 2.7% |
| Other values (32) | 12483 |
Shipping Address Country
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 337.8 KiB |
| IN |
|---|
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | IN |
|---|---|
| 2nd row | IN |
| 3rd row | IN |
| 4th row | IN |
| 5th row | IN |
Common Values
| Value | Count | Frequency (%) |
| IN | 5860 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| in | 5860 |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 5860 | |
| N | 5860 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 11720 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 5860 | |
| N | 5860 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 11720 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| I | 5860 | |
| N | 5860 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11720 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| I | 5860 | |
| N | 5860 |
Shipping Address Pincode
Real number (ℝ)
High correlation 
| Distinct | 2104 |
|---|---|
| Distinct (%) | 35.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 395816.75 |
| Minimum | 110001 |
|---|---|
| Maximum | 855101 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 45.9 KiB |
Quantile statistics
| Minimum | 110001 |
|---|---|
| 5-th percentile | 110060 |
| Q1 | 201306 |
| median | 400064 |
| Q3 | 560024 |
| 95-th percentile | 803214.05 |
| Maximum | 855101 |
| Range | 745100 |
| Interquartile range (IQR) | 358718 |
Descriptive statistics
| Standard deviation | 218087.94 |
|---|---|
| Coefficient of variation (CV) | 0.55098209 |
| Kurtosis | -0.78969982 |
| Mean | 395816.75 |
| Median Absolute Deviation (MAD) | 172063 |
| Skewness | 0.43807072 |
| Sum | 2.3194861 × 109 |
| Variance | 4.7562349 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 201301 | 105 | 1.8% |
| 122001 | 75 | 1.3% |
| 122002 | 36 | 0.6% |
| 401107 | 35 | 0.6% |
| 201306 | 34 | 0.6% |
| 110085 | 33 | 0.6% |
| 560037 | 27 | 0.5% |
| 122003 | 25 | 0.4% |
| 560068 | 25 | 0.4% |
| 560035 | 24 | 0.4% |
| Other values (2094) | 5441 |
| Value | Count | Frequency (%) |
| 110001 | 3 | 0.1% |
| 110002 | 1 | < 0.1% |
| 110003 | 3 | 0.1% |
| 110005 | 7 | 0.1% |
| 110007 | 12 | |
| 110008 | 13 | |
| 110009 | 18 | |
| 110010 | 2 | < 0.1% |
| 110012 | 2 | < 0.1% |
| 110014 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 855101 | 2 | |
| 854327 | 1 | |
| 854326 | 1 | |
| 854318 | 2 | |
| 854311 | 2 | |
| 854304 | 1 | |
| 854301 | 1 | |
| 854205 | 2 | |
| 854109 | 1 | |
| 854105 | 1 |
Billing Address Id
Real number (ℝ)
High correlation 
| Distinct | 5680 |
|---|---|
| Distinct (%) | 96.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19079918 |
| Minimum | 17037894 |
|---|---|
| Maximum | 20951989 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 45.9 KiB |
Quantile statistics
| Minimum | 17037894 |
|---|---|
| 5-th percentile | 17307195 |
| Q1 | 18267788 |
| median | 18918412 |
| Q3 | 20102973 |
| 95-th percentile | 20824217 |
| Maximum | 20951989 |
| Range | 3914095 |
| Interquartile range (IQR) | 1835185 |
Descriptive statistics
| Standard deviation | 1091279.9 |
|---|---|
| Coefficient of variation (CV) | 0.057195206 |
| Kurtosis | -1.0743422 |
| Mean | 19079918 |
| Median Absolute Deviation (MAD) | 810727 |
| Skewness | 0.1165908 |
| Sum | 1.1180832 × 1011 |
| Variance | 1.1908918 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 18030566 | 5 | 0.1% |
| 17147660 | 4 | 0.1% |
| 18634020 | 4 | 0.1% |
| 18260913 | 4 | 0.1% |
| 18603959 | 4 | 0.1% |
| 18259525 | 4 | 0.1% |
| 18409077 | 3 | 0.1% |
| 18317699 | 3 | 0.1% |
| 18504226 | 3 | 0.1% |
| 18277293 | 3 | 0.1% |
| Other values (5670) | 5823 |
| Value | Count | Frequency (%) |
| 17037894 | 1 | |
| 17038428 | 1 | |
| 17039695 | 1 | |
| 17048515 | 1 | |
| 17052967 | 1 | |
| 17055540 | 1 | |
| 17057290 | 1 | |
| 17058667 | 1 | |
| 17058904 | 1 | |
| 17059345 | 1 |
| Value | Count | Frequency (%) |
| 20951989 | 1 | |
| 20950770 | 1 | |
| 20949763 | 1 | |
| 20949385 | 1 | |
| 20949182 | 1 | |
| 20948869 | 1 | |
| 20948572 | 1 | |
| 20948430 | 1 | |
| 20948416 | 1 | |
| 20948258 | 1 |
| Distinct | 955 |
|---|---|
| Distinct (%) | 16.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 370.7 KiB |
Length
| Max length | 21 |
|---|---|
| Median length | 18 |
| Mean length | 7.7609215 |
| Min length | 3 |
Unique
| Unique | 442 ? |
|---|---|
| Unique (%) | 7.5% |
Sample
| 1st row | Raebareli |
|---|---|
| 2nd row | Phagwara |
| 3rd row | Berhampore |
| 4th row | Hyderabad |
| 5th row | Kolkata |
| Value | Count | Frequency (%) |
| delhi | 495 | 7.4% |
| new | 330 | 4.9% |
| mumbai | 330 | 4.9% |
| bangalore | 280 | 4.2% |
| pune | 200 | 3.0% |
| gurgaon | 181 | 2.7% |
| noida | 157 | 2.4% |
| hyderabad | 147 | 2.2% |
| nagar | 122 | 1.8% |
| bengaluru | 118 | 1.8% |
| Other values (918) | 4308 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 8240 | |
| r | 3437 | 7.6% |
| u | 2777 | 6.1% |
| i | 2597 | 5.7% |
| e | 2552 | 5.6% |
| n | 2411 | 5.3% |
| h | 2306 | 5.1% |
| d | 1916 | 4.2% |
| l | 1841 | 4.0% |
| o | 1640 | 3.6% |
| Other values (46) | 15762 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 37624 | |
| Uppercase Letter | 6869 | 15.1% |
| Space Separator | 879 | 1.9% |
| Other Punctuation | 74 | 0.2% |
| Open Punctuation | 10 | < 0.1% |
| Close Punctuation | 10 | < 0.1% |
| Decimal Number | 8 | < 0.1% |
| Dash Punctuation | 5 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 8240 | |
| r | 3437 | |
| u | 2777 | 7.4% |
| i | 2597 | 6.9% |
| e | 2552 | 6.8% |
| n | 2411 | 6.4% |
| h | 2306 | 6.1% |
| d | 1916 | 5.1% |
| l | 1841 | 4.9% |
| o | 1640 | 4.4% |
| Other values (15) | 7907 |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 915 | |
| N | 800 | |
| G | 686 | |
| D | 627 | |
| M | 565 | 8.2% |
| P | 430 | 6.3% |
| A | 393 | 5.7% |
| K | 383 | 5.6% |
| J | 304 | 4.4% |
| S | 282 | 4.1% |
| Other values (14) | 1484 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 4 | |
| 4 | 4 |
Space Separator
| Value | Count | Frequency (%) |
| 879 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 74 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 10 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 10 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 44493 | |
| Common | 986 | 2.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 8240 | |
| r | 3437 | 7.7% |
| u | 2777 | 6.2% |
| i | 2597 | 5.8% |
| e | 2552 | 5.7% |
| n | 2411 | 5.4% |
| h | 2306 | 5.2% |
| d | 1916 | 4.3% |
| l | 1841 | 4.1% |
| o | 1640 | 3.7% |
| Other values (39) | 14776 |
Common
| Value | Count | Frequency (%) |
| 879 | ||
| , | 74 | 7.5% |
| ( | 10 | 1.0% |
| ) | 10 | 1.0% |
| - | 5 | 0.5% |
| 2 | 4 | 0.4% |
| 4 | 4 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 45479 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 8240 | |
| r | 3437 | 7.6% |
| u | 2777 | 6.1% |
| i | 2597 | 5.7% |
| e | 2552 | 5.6% |
| n | 2411 | 5.3% |
| h | 2306 | 5.1% |
| d | 1916 | 4.2% |
| l | 1841 | 4.0% |
| o | 1640 | 3.6% |
| Other values (46) | 15762 |
Billing Address State
Categorical
High correlation 
| Distinct | 35 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 380.8 KiB |
| Uttar Pradesh | |
|---|---|
| Maharashtra | |
| Delhi | |
| Karnataka | |
| Haryana | |
| Other values (30) |
Length
| Max length | 40 |
|---|---|
| Median length | 17 |
| Mean length | 9.5187713 |
| Min length | 3 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Uttar Pradesh |
|---|---|
| 2nd row | Punjab |
| 3rd row | West Bengal |
| 4th row | Telangana |
| 5th row | West Bengal |
Common Values
| Value | Count | Frequency (%) |
| Uttar Pradesh | 935 | |
| Maharashtra | 830 | |
| Delhi | 495 | |
| Karnataka | 482 | 8.2% |
| Haryana | 470 | 8.0% |
| Madhya Pradesh | 340 | 5.8% |
| Gujarat | 310 | 5.3% |
| Rajasthan | 281 | 4.8% |
| Bihar | 273 | 4.7% |
| West Bengal | 215 | 3.7% |
| Other values (25) | 1229 |
Length
| Value | Count | Frequency (%) |
| pradesh | 1390 | |
| uttar | 935 | |
| maharashtra | 830 | |
| delhi | 495 | 6.4% |
| karnataka | 482 | 6.3% |
| haryana | 470 | 6.1% |
| madhya | 340 | 4.4% |
| gujarat | 310 | 4.0% |
| rajasthan | 281 | 3.7% |
| bihar | 273 | 3.6% |
| Other values (36) | 1877 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 13859 | |
| r | 6081 | |
| h | 5410 | 9.7% |
| t | 4332 | 7.8% |
| s | 3148 | 5.6% |
| e | 2550 | 4.6% |
| n | 2281 | 4.1% |
| d | 2280 | 4.1% |
| 1823 | 3.3% | |
| P | 1533 | 2.7% |
| Other values (32) | 12483 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 46277 | |
| Uppercase Letter | 7631 | 13.7% |
| Space Separator | 1823 | 3.3% |
| Other Punctuation | 49 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 13859 | |
| r | 6081 | |
| h | 5410 | 11.7% |
| t | 4332 | 9.4% |
| s | 3148 | 6.8% |
| e | 2550 | 5.5% |
| n | 2281 | 4.9% |
| d | 2280 | 4.9% |
| i | 1235 | 2.7% |
| l | 1093 | 2.4% |
| Other values (12) | 4008 | 8.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 1533 | |
| M | 1176 | |
| U | 1005 | |
| K | 577 | 7.6% |
| D | 502 | 6.6% |
| H | 499 | 6.5% |
| B | 488 | 6.4% |
| G | 338 | 4.4% |
| T | 297 | 3.9% |
| R | 281 | 3.7% |
| Other values (8) | 935 |
Space Separator
| Value | Count | Frequency (%) |
| 1823 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 49 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 53908 | |
| Common | 1872 | 3.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 13859 | |
| r | 6081 | |
| h | 5410 | 10.0% |
| t | 4332 | 8.0% |
| s | 3148 | 5.8% |
| e | 2550 | 4.7% |
| n | 2281 | 4.2% |
| d | 2280 | 4.2% |
| P | 1533 | 2.8% |
| i | 1235 | 2.3% |
| Other values (30) | 11199 |
Common
| Value | Count | Frequency (%) |
| 1823 | ||
| & | 49 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 55780 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 13859 | |
| r | 6081 | |
| h | 5410 | 9.7% |
| t | 4332 | 7.8% |
| s | 3148 | 5.6% |
| e | 2550 | 4.6% |
| n | 2281 | 4.1% |
| d | 2280 | 4.1% |
| 1823 | 3.3% | |
| P | 1533 | 2.7% |
| Other values (32) | 12483 |
Billing Address Country
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 337.8 KiB |
| IN |
|---|
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | IN |
|---|---|
| 2nd row | IN |
| 3rd row | IN |
| 4th row | IN |
| 5th row | IN |
Common Values
| Value | Count | Frequency (%) |
| IN | 5860 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| in | 5860 |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 5860 | |
| N | 5860 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 11720 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 5860 | |
| N | 5860 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 11720 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| I | 5860 | |
| N | 5860 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11720 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| I | 5860 | |
| N | 5860 |
Billing Address Pincode
Real number (ℝ)
High correlation 
| Distinct | 2104 |
|---|---|
| Distinct (%) | 35.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 395816.75 |
| Minimum | 110001 |
|---|---|
| Maximum | 855101 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 45.9 KiB |
Quantile statistics
| Minimum | 110001 |
|---|---|
| 5-th percentile | 110060 |
| Q1 | 201306 |
| median | 400064 |
| Q3 | 560024 |
| 95-th percentile | 803214.05 |
| Maximum | 855101 |
| Range | 745100 |
| Interquartile range (IQR) | 358718 |
Descriptive statistics
| Standard deviation | 218087.94 |
|---|---|
| Coefficient of variation (CV) | 0.55098209 |
| Kurtosis | -0.78969982 |
| Mean | 395816.75 |
| Median Absolute Deviation (MAD) | 172063 |
| Skewness | 0.43807072 |
| Sum | 2.3194861 × 109 |
| Variance | 4.7562349 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 201301 | 105 | 1.8% |
| 122001 | 75 | 1.3% |
| 122002 | 36 | 0.6% |
| 401107 | 35 | 0.6% |
| 201306 | 34 | 0.6% |
| 110085 | 33 | 0.6% |
| 560037 | 27 | 0.5% |
| 122003 | 25 | 0.4% |
| 560068 | 25 | 0.4% |
| 560035 | 24 | 0.4% |
| Other values (2094) | 5441 |
| Value | Count | Frequency (%) |
| 110001 | 3 | 0.1% |
| 110002 | 1 | < 0.1% |
| 110003 | 3 | 0.1% |
| 110005 | 7 | 0.1% |
| 110007 | 12 | |
| 110008 | 13 | |
| 110009 | 18 | |
| 110010 | 2 | < 0.1% |
| 110012 | 2 | < 0.1% |
| 110014 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 855101 | 2 | |
| 854327 | 1 | |
| 854326 | 1 | |
| 854318 | 2 | |
| 854311 | 2 | |
| 854304 | 1 | |
| 854301 | 1 | |
| 854205 | 2 | |
| 854109 | 1 | |
| 854105 | 1 |
Shipping Method
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 343.5 KiB |
| STD |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | STD |
|---|---|
| 2nd row | STD |
| 3rd row | STD |
| 4th row | STD |
| 5th row | STD |
Common Values
| Value | Count | Frequency (%) |
| STD | 5860 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| std | 5860 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 5860 | |
| T | 5860 | |
| D | 5860 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 17580 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 5860 | |
| T | 5860 | |
| D | 5860 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 17580 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 5860 | |
| T | 5860 | |
| D | 5860 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 5860 | |
| T | 5860 | |
| D | 5860 |
Item SKU Code
Text
| Distinct | 440 |
|---|---|
| Distinct (%) | 7.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 393.3 KiB |
Length
| Max length | 17 |
|---|---|
| Median length | 16 |
| Mean length | 11.706655 |
| Min length | 9 |
Unique
| Unique | 72 ? |
|---|---|
| Unique (%) | 1.2% |
Sample
| 1st row | ADGRN035-M |
|---|---|
| 2nd row | ADKSET151-2XL |
| 3rd row | ADKSET147-L |
| 4th row | ADYLW036-S |
| 5th row | ADKSET261-L |
| Value | Count | Frequency (%) |
| adcrdset159-s | 125 | 2.1% |
| adcrdset159-m | 120 | 2.0% |
| adkset157-s | 89 | 1.5% |
| adjmp145-s | 87 | 1.5% |
| adkset148-m | 87 | 1.5% |
| adkset157-m | 84 | 1.4% |
| adcrdset159-l | 83 | 1.4% |
| adcrdset159-xs | 81 | 1.4% |
| adkset261-s | 80 | 1.4% |
| adkset148-l | 73 | 1.2% |
| Other values (430) | 4951 |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 7450 | 10.9% |
| A | 6529 | 9.5% |
| S | 6388 | 9.3% |
| - | 5860 | 8.5% |
| 1 | 4335 | 6.3% |
| T | 4245 | 6.2% |
| E | 3976 | 5.8% |
| L | 3021 | 4.4% |
| K | 2729 | 4.0% |
| 2 | 2666 | 3.9% |
| Other values (23) | 21402 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 44797 | |
| Decimal Number | 17944 | |
| Dash Punctuation | 5860 | 8.5% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 7450 | |
| A | 6529 | |
| S | 6388 | |
| T | 4245 | |
| E | 3976 | |
| L | 3021 | |
| K | 2729 | 6.1% |
| X | 2180 | 4.9% |
| M | 1809 | 4.0% |
| R | 1796 | 4.0% |
| Other values (12) | 4674 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 4335 | |
| 2 | 2666 | |
| 0 | 2237 | |
| 5 | 1981 | |
| 6 | 1694 | 9.4% |
| 4 | 1492 | 8.3% |
| 7 | 1019 | 5.7% |
| 8 | 875 | 4.9% |
| 9 | 855 | 4.8% |
| 3 | 790 | 4.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5860 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 44797 | |
| Common | 23804 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| D | 7450 | |
| A | 6529 | |
| S | 6388 | |
| T | 4245 | |
| E | 3976 | |
| L | 3021 | |
| K | 2729 | 6.1% |
| X | 2180 | 4.9% |
| M | 1809 | 4.0% |
| R | 1796 | 4.0% |
| Other values (12) | 4674 |
Common
| Value | Count | Frequency (%) |
| - | 5860 | |
| 1 | 4335 | |
| 2 | 2666 | |
| 0 | 2237 | 9.4% |
| 5 | 1981 | 8.3% |
| 6 | 1694 | 7.1% |
| 4 | 1492 | 6.3% |
| 7 | 1019 | 4.3% |
| 8 | 875 | 3.7% |
| 9 | 855 | 3.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 68601 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| D | 7450 | 10.9% |
| A | 6529 | 9.5% |
| S | 6388 | 9.3% |
| - | 5860 | 8.5% |
| 1 | 4335 | 6.3% |
| T | 4245 | 6.2% |
| E | 3976 | 5.8% |
| L | 3021 | 4.4% |
| K | 2729 | 4.0% |
| 2 | 2666 | 3.9% |
| Other values (23) | 21402 |
Item Type Name
Text
| Distinct | 91 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 639.7 KiB |
Length
| Max length | 89 |
|---|---|
| Median length | 77 |
| Mean length | 54.766041 |
| Min length | 18 |
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Women Panelled Gotta Patti Chanderi Silk Kurta with Palazzos & With Dupatta |
|---|---|
| 2nd row | Ethnic Motifs Yoke Design Gotta Patti Chanderi Silk Kurta with Churidar & Dupatta |
| 3rd row | Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta |
| 4th row | Leheriya Embroidered Empire Beads and Stones Silk Crepe Kurta Churidar & Dupatta |
| 5th row | Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatta |
| Value | Count | Frequency (%) |
| with | 6046 | 12.7% |
| kurta | 3423 | 7.2% |
| 2900 | 6.1% | |
| dupatta | 2725 | 5.7% |
| embroidered | 1970 | 4.1% |
| women | 1864 | 3.9% |
| churidar | 1857 | 3.9% |
| regular | 1494 | 3.1% |
| ethnic | 1025 | 2.1% |
| sequinned | 957 | 2.0% |
| Other values (94) | 23469 |
Most occurring characters
| Value | Count | Frequency (%) |
| 41870 | 13.0% | |
| r | 25494 | 7.9% |
| t | 24652 | 7.7% |
| a | 24399 | 7.6% |
| e | 23982 | 7.5% |
| i | 20749 | 6.5% |
| o | 14730 | 4.6% |
| u | 13561 | 4.2% |
| d | 12746 | 4.0% |
| h | 12224 | 3.8% |
| Other values (42) | 106522 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 230976 | |
| Uppercase Letter | 43374 | 13.5% |
| Space Separator | 41870 | 13.0% |
| Other Punctuation | 2903 | 0.9% |
| Dash Punctuation | 1603 | 0.5% |
| Decimal Number | 203 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 25494 | |
| t | 24652 | |
| a | 24399 | |
| e | 23982 | |
| i | 20749 | |
| o | 14730 | 6.4% |
| u | 13561 | 5.9% |
| d | 12746 | 5.5% |
| h | 12224 | 5.3% |
| n | 11731 | 5.1% |
| Other values (15) | 46708 |
Uppercase Letter
| Value | Count | Frequency (%) |
| W | 6644 | |
| C | 5130 | |
| D | 4088 | |
| S | 3983 | |
| E | 3743 | |
| K | 3592 | |
| P | 3378 | |
| T | 2560 | 5.9% |
| R | 1926 | 4.4% |
| O | 1087 | 2.5% |
| Other values (12) | 7243 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 2900 | |
| , | 3 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 41870 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1603 |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 203 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 274350 | |
| Common | 46579 | 14.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 25494 | 9.3% |
| t | 24652 | 9.0% |
| a | 24399 | 8.9% |
| e | 23982 | 8.7% |
| i | 20749 | 7.6% |
| o | 14730 | 5.4% |
| u | 13561 | 4.9% |
| d | 12746 | 4.6% |
| h | 12224 | 4.5% |
| n | 11731 | 4.3% |
| Other values (37) | 90082 |
Common
| Value | Count | Frequency (%) |
| 41870 | ||
| & | 2900 | 6.2% |
| - | 1603 | 3.4% |
| 3 | 203 | 0.4% |
| , | 3 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 320929 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 41870 | 13.0% | |
| r | 25494 | 7.9% |
| t | 24652 | 7.7% |
| a | 24399 | 7.6% |
| e | 23982 | 7.5% |
| i | 20749 | 6.5% |
| o | 14730 | 4.6% |
| u | 13561 | 4.2% |
| d | 12746 | 4.0% |
| h | 12224 | 3.8% |
| Other values (42) | 106522 |
Item Type Color
Categorical
High correlation  Missing 
| Distinct | 10 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 4961 |
| Missing (%) | 84.7% |
| Memory size | 365.4 KiB |
| Burgandy | |
|---|---|
| Cream | |
| Green | |
| Red | |
| Teal | 10 |
| Other values (5) | 17 |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 5.8809789 |
| Min length | 3 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | Green |
|---|---|
| 2nd row | Cream |
| 3rd row | Cream |
| 4th row | Cream |
| 5th row | Burgandy |
Common Values
| Value | Count | Frequency (%) |
| Burgandy | 336 | 5.7% |
| Cream | 216 | 3.7% |
| Green | 215 | 3.7% |
| Red | 105 | 1.8% |
| Teal | 10 | 0.2% |
| WHITE | 9 | 0.2% |
| BLACK | 3 | 0.1% |
| BEIGE | 3 | 0.1% |
| Navy Blue | 1 | < 0.1% |
| GREEN | 1 | < 0.1% |
| (Missing) | 4961 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| burgandy | 336 | |
| cream | 216 | |
| green | 216 | |
| red | 105 | 11.7% |
| teal | 10 | 1.1% |
| white | 9 | 1.0% |
| black | 3 | 0.3% |
| beige | 3 | 0.3% |
| navy | 1 | 0.1% |
| blue | 1 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 767 | |
| e | 762 | |
| a | 563 | |
| n | 551 | |
| d | 441 | |
| B | 343 | |
| u | 337 | |
| y | 337 | |
| g | 336 | |
| C | 219 | 4.1% |
| Other values (15) | 631 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 4322 | |
| Uppercase Letter | 964 | 18.2% |
| Space Separator | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 343 | |
| C | 219 | |
| G | 219 | |
| R | 106 | 11.0% |
| T | 19 | 2.0% |
| E | 17 | 1.8% |
| I | 12 | 1.2% |
| W | 9 | 0.9% |
| H | 9 | 0.9% |
| L | 3 | 0.3% |
| Other values (3) | 8 | 0.8% |
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 767 | |
| e | 762 | |
| a | 563 | |
| n | 551 | |
| d | 441 | |
| u | 337 | |
| y | 337 | |
| g | 336 | |
| m | 216 | 5.0% |
| l | 11 | 0.3% |
Space Separator
| Value | Count | Frequency (%) |
| 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5286 | |
| Common | 1 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 767 | |
| e | 762 | |
| a | 563 | |
| n | 551 | |
| d | 441 | |
| B | 343 | |
| u | 337 | |
| y | 337 | |
| g | 336 | |
| C | 219 | 4.1% |
| Other values (14) | 630 |
Common
| Value | Count | Frequency (%) |
| 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5287 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 767 | |
| e | 762 | |
| a | 563 | |
| n | 551 | |
| d | 441 | |
| B | 343 | |
| u | 337 | |
| y | 337 | |
| g | 336 | |
| C | 219 | 4.1% |
| Other values (15) | 631 |
Channel Name
Categorical
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 387.1 KiB |
| MYNTRAPPMP | |
|---|---|
| NYKAA_FASHION |
Length
| Max length | 13 |
|---|---|
| Median length | 10 |
| Mean length | 10.612799 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | NYKAA_FASHION |
|---|---|
| 2nd row | NYKAA_FASHION |
| 3rd row | NYKAA_FASHION |
| 4th row | MYNTRAPPMP |
| 5th row | MYNTRAPPMP |
Common Values
| Value | Count | Frequency (%) |
| MYNTRAPPMP | 4663 | |
| NYKAA_FASHION | 1197 | 20.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| myntrappmp | 4663 | |
| nykaa_fashion | 1197 | 20.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 13989 | |
| M | 9326 | |
| A | 8254 | |
| N | 7057 | |
| Y | 5860 | |
| T | 4663 | 7.5% |
| R | 4663 | 7.5% |
| K | 1197 | 1.9% |
| _ | 1197 | 1.9% |
| F | 1197 | 1.9% |
| Other values (4) | 4788 | 7.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 60994 | |
| Connector Punctuation | 1197 | 1.9% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 13989 | |
| M | 9326 | |
| A | 8254 | |
| N | 7057 | |
| Y | 5860 | |
| T | 4663 | 7.6% |
| R | 4663 | 7.6% |
| K | 1197 | 2.0% |
| F | 1197 | 2.0% |
| S | 1197 | 2.0% |
| Other values (3) | 3591 | 5.9% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 1197 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 60994 | |
| Common | 1197 | 1.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 13989 | |
| M | 9326 | |
| A | 8254 | |
| N | 7057 | |
| Y | 5860 | |
| T | 4663 | 7.6% |
| R | 4663 | 7.6% |
| K | 1197 | 2.0% |
| F | 1197 | 2.0% |
| S | 1197 | 2.0% |
| Other values (3) | 3591 | 5.9% |
Common
| Value | Count | Frequency (%) |
| _ | 1197 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 62191 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| P | 13989 | |
| M | 9326 | |
| A | 8254 | |
| N | 7057 | |
| Y | 5860 | |
| T | 4663 | 7.5% |
| R | 4663 | 7.5% |
| K | 1197 | 1.9% |
| _ | 1197 | 1.9% |
| F | 1197 | 1.9% |
| Other values (4) | 4788 | 7.7% |
Gift Wrap
Boolean
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.9 KiB |
| False |
|---|
| Value | Count | Frequency (%) |
| False | 5860 |
HSN Code
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 43 |
| Missing (%) | 0.7% |
| Memory size | 383.4 KiB |
| 62045300.0 |
|---|
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 62045300.0 |
|---|---|
| 2nd row | 62045300.0 |
| 3rd row | 62045300.0 |
| 4th row | 62045300.0 |
| 5th row | 62045300.0 |
Common Values
| Value | Count | Frequency (%) |
| 62045300.0 | 5817 | |
| (Missing) | 43 | 0.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 62045300.0 | 5817 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 23268 | |
| 6 | 5817 | 10.0% |
| 2 | 5817 | 10.0% |
| 4 | 5817 | 10.0% |
| 5 | 5817 | 10.0% |
| 3 | 5817 | 10.0% |
| . | 5817 | 10.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 52353 | |
| Other Punctuation | 5817 | 10.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 23268 | |
| 6 | 5817 | 11.1% |
| 2 | 5817 | 11.1% |
| 4 | 5817 | 11.1% |
| 5 | 5817 | 11.1% |
| 3 | 5817 | 11.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 5817 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 58170 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 23268 | |
| 6 | 5817 | 10.0% |
| 2 | 5817 | 10.0% |
| 4 | 5817 | 10.0% |
| 5 | 5817 | 10.0% |
| 3 | 5817 | 10.0% |
| . | 5817 | 10.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 58170 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 23268 | |
| 6 | 5817 | 10.0% |
| 2 | 5817 | 10.0% |
| 4 | 5817 | 10.0% |
| 5 | 5817 | 10.0% |
| 3 | 5817 | 10.0% |
| . | 5817 | 10.0% |
MRP
Real number (ℝ)
High correlation  Missing 
| Distinct | 32 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 188 |
| Missing (%) | 3.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5329.8062 |
| Minimum | 1599 |
|---|---|
| Maximum | 12999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 45.9 KiB |
Quantile statistics
| Minimum | 1599 |
|---|---|
| 5-th percentile | 3499 |
| Q1 | 4299 |
| median | 4999 |
| Q3 | 6499 |
| 95-th percentile | 6999 |
| Maximum | 12999 |
| Range | 11400 |
| Interquartile range (IQR) | 2200 |
Descriptive statistics
| Standard deviation | 1311.6218 |
|---|---|
| Coefficient of variation (CV) | 0.24609183 |
| Kurtosis | 1.5761615 |
| Mean | 5329.8062 |
| Median Absolute Deviation (MAD) | 1000 |
| Skewness | 0.76161937 |
| Sum | 30230661 |
| Variance | 1720351.7 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3999 | 884 | |
| 4999 | 638 | |
| 6499 | 548 | |
| 5999 | 423 | 7.2% |
| 6599 | 404 | 6.9% |
| 4499 | 342 | 5.8% |
| 6299 | 320 | 5.5% |
| 6999 | 303 | 5.2% |
| 4599 | 282 | 4.8% |
| 5499 | 252 | 4.3% |
| Other values (22) | 1276 |
| Value | Count | Frequency (%) |
| 1599 | 1 | < 0.1% |
| 1899 | 3 | 0.1% |
| 2799 | 12 | 0.2% |
| 2999 | 51 | 0.9% |
| 3299 | 118 | 2.0% |
| 3499 | 216 | 3.7% |
| 3599 | 37 | 0.6% |
| 3999 | 884 | |
| 4099 | 4 | 0.1% |
| 4122 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 12999 | 2 | < 0.1% |
| 10999 | 41 | 0.7% |
| 8899 | 26 | 0.4% |
| 7999 | 134 | 2.3% |
| 7500 | 3 | 0.1% |
| 7499 | 37 | 0.6% |
| 6999 | 303 | |
| 6599 | 404 | |
| 6499 | 548 | |
| 6299 | 320 |
Total Price
Real number (ℝ)
High correlation 
| Distinct | 279 |
|---|---|
| Distinct (%) | 4.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3424.9193 |
| Minimum | 879 |
|---|---|
| Maximum | 8999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 45.9 KiB |
Quantile statistics
| Minimum | 879 |
|---|---|
| 5-th percentile | 2239 |
| Q1 | 2639 |
| median | 3330 |
| Q3 | 4199 |
| 95-th percentile | 4639 |
| Maximum | 8999 |
| Range | 8120 |
| Interquartile range (IQR) | 1560 |
Descriptive statistics
| Standard deviation | 919.10866 |
|---|---|
| Coefficient of variation (CV) | 0.26835922 |
| Kurtosis | 1.5546684 |
| Mean | 3424.9193 |
| Median Absolute Deviation (MAD) | 761 |
| Skewness | 0.48309537 |
| Sum | 20070027 |
| Variance | 844760.73 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3299 | 278 | 4.7% |
| 3899 | 270 | 4.6% |
| 4487 | 249 | 4.2% |
| 2519 | 238 | 4.1% |
| 4283 | 168 | 2.9% |
| 2309 | 134 | 2.3% |
| 4289 | 114 | 1.9% |
| 4211 | 108 | 1.8% |
| 3127 | 105 | 1.8% |
| 2719 | 103 | 1.8% |
| Other values (269) | 4093 |
| Value | Count | Frequency (%) |
| 879 | 1 | < 0.1% |
| 1006 | 2 | < 0.1% |
| 1045 | 1 | < 0.1% |
| 1199 | 2 | < 0.1% |
| 1200 | 1 | < 0.1% |
| 1253 | 6 | 0.1% |
| 1254 | 4 | 0.1% |
| 1319 | 34 | |
| 1320 | 11 | 0.2% |
| 1379 | 7 | 0.1% |
| Value | Count | Frequency (%) |
| 8999 | 1 | < 0.1% |
| 7699 | 4 | 0.1% |
| 7480 | 2 | < 0.1% |
| 7479 | 34 | |
| 6999 | 1 | < 0.1% |
| 6499 | 1 | < 0.1% |
| 6230 | 1 | < 0.1% |
| 5999 | 3 | 0.1% |
| 5599 | 3 | 0.1% |
| 5399 | 1 | < 0.1% |
Selling Price
Real number (ℝ)
High correlation 
| Distinct | 279 |
|---|---|
| Distinct (%) | 4.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3424.9193 |
| Minimum | 879 |
|---|---|
| Maximum | 8999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 45.9 KiB |
Quantile statistics
| Minimum | 879 |
|---|---|
| 5-th percentile | 2239 |
| Q1 | 2639 |
| median | 3330 |
| Q3 | 4199 |
| 95-th percentile | 4639 |
| Maximum | 8999 |
| Range | 8120 |
| Interquartile range (IQR) | 1560 |
Descriptive statistics
| Standard deviation | 919.10866 |
|---|---|
| Coefficient of variation (CV) | 0.26835922 |
| Kurtosis | 1.5546684 |
| Mean | 3424.9193 |
| Median Absolute Deviation (MAD) | 761 |
| Skewness | 0.48309537 |
| Sum | 20070027 |
| Variance | 844760.73 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3299 | 278 | 4.7% |
| 3899 | 270 | 4.6% |
| 4487 | 249 | 4.2% |
| 2519 | 238 | 4.1% |
| 4283 | 168 | 2.9% |
| 2309 | 134 | 2.3% |
| 4289 | 114 | 1.9% |
| 4211 | 108 | 1.8% |
| 3127 | 105 | 1.8% |
| 2719 | 103 | 1.8% |
| Other values (269) | 4093 |
| Value | Count | Frequency (%) |
| 879 | 1 | < 0.1% |
| 1006 | 2 | < 0.1% |
| 1045 | 1 | < 0.1% |
| 1199 | 2 | < 0.1% |
| 1200 | 1 | < 0.1% |
| 1253 | 6 | 0.1% |
| 1254 | 4 | 0.1% |
| 1319 | 34 | |
| 1320 | 11 | 0.2% |
| 1379 | 7 | 0.1% |
| Value | Count | Frequency (%) |
| 8999 | 1 | < 0.1% |
| 7699 | 4 | 0.1% |
| 7480 | 2 | < 0.1% |
| 7479 | 34 | |
| 6999 | 1 | < 0.1% |
| 6499 | 1 | < 0.1% |
| 6230 | 1 | < 0.1% |
| 5999 | 3 | 0.1% |
| 5599 | 3 | 0.1% |
| 5399 | 1 | < 0.1% |
Cost Price
Unsupported
Missing  Rejected  Unsupported 
| Missing | 5860 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 45.9 KiB |
Prepaid Amount
Real number (ℝ)
High correlation  Zeros 
| Distinct | 445 |
|---|---|
| Distinct (%) | 7.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 347.20062 |
| Minimum | 0 |
|---|---|
| Maximum | 7450 |
| Zeros | 5195 |
| Zeros (%) | 88.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 45.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 3059.205 |
| Maximum | 7450 |
| Range | 7450 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1030.5199 |
|---|---|
| Coefficient of variation (CV) | 2.9680818 |
| Kurtosis | 7.7425593 |
| Mean | 347.20062 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.9465252 |
| Sum | 2034595.7 |
| Variance | 1061971.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5195 | |
| 2520 | 17 | 0.3% |
| 2240 | 10 | 0.2% |
| 2640 | 9 | 0.2% |
| 4440 | 9 | 0.2% |
| 3500 | 9 | 0.2% |
| 4800 | 8 | 0.1% |
| 4488 | 7 | 0.1% |
| 2800 | 6 | 0.1% |
| 4560 | 6 | 0.1% |
| Other values (435) | 584 | 10.0% |
| Value | Count | Frequency (%) |
| 0 | 5195 | |
| 0.23 | 1 | < 0.1% |
| 11.5 | 1 | < 0.1% |
| 50 | 1 | < 0.1% |
| 99 | 1 | < 0.1% |
| 190.5 | 2 | < 0.1% |
| 228.87 | 1 | < 0.1% |
| 239 | 1 | < 0.1% |
| 281 | 1 | < 0.1% |
| 301 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 7450 | 1 | < 0.1% |
| 7250 | 1 | < 0.1% |
| 5340 | 3 | |
| 5310 | 1 | < 0.1% |
| 5228 | 1 | < 0.1% |
| 5200 | 1 | < 0.1% |
| 5191.3 | 1 | < 0.1% |
| 5020 | 1 | < 0.1% |
| 4999 | 1 | < 0.1% |
| 4862 | 1 | < 0.1% |
Subtotal
Real number (ℝ)
High correlation 
| Distinct | 403 |
|---|---|
| Distinct (%) | 6.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4597.0289 |
| Minimum | 995.24 |
|---|---|
| Maximum | 10197.68 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 45.9 KiB |
Quantile statistics
| Minimum | 995.24 |
|---|---|
| 5-th percentile | 2250 |
| Q1 | 3707.68 |
| median | 4285.71 |
| Q3 | 5853.61 |
| 95-th percentile | 6624.11 |
| Maximum | 10197.68 |
| Range | 9202.44 |
| Interquartile range (IQR) | 2145.93 |
Descriptive statistics
| Standard deviation | 1440.8683 |
|---|---|
| Coefficient of variation (CV) | 0.31343468 |
| Kurtosis | 0.31872993 |
| Mean | 4597.0289 |
| Median Absolute Deviation (MAD) | 1041.6 |
| Skewness | 0.34239951 |
| Sum | 26938589 |
| Variance | 2076101.3 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4645.54 | 278 | 4.7% |
| 6081.25 | 220 | 3.8% |
| 6118.25 | 201 | 3.4% |
| 5840.11 | 143 | 2.4% |
| 3729.11 | 124 | 2.1% |
| 5039.46 | 114 | 1.9% |
| 4947.82 | 108 | 1.8% |
| 4263.96 | 105 | 1.8% |
| 3707.68 | 103 | 1.8% |
| 3995.04 | 102 | 1.7% |
| Other values (393) | 4362 |
| Value | Count | Frequency (%) |
| 995.24 | 1 | < 0.1% |
| 1071.43 | 1 | < 0.1% |
| 1119.64 | 4 | 0.1% |
| 1178.57 | 11 | |
| 1275 | 2 | < 0.1% |
| 1285.71 | 2 | < 0.1% |
| 1285.72 | 1 | < 0.1% |
| 1325 | 5 | |
| 1392.86 | 3 | 0.1% |
| 1399.12 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 10197.68 | 34 | |
| 10174.11 | 4 | 0.1% |
| 8346.04 | 8 | 0.1% |
| 8326.96 | 8 | 0.1% |
| 8034.82 | 1 | < 0.1% |
| 7656.25 | 1 | < 0.1% |
| 7656.24 | 3 | 0.1% |
| 7570.54 | 5 | 0.1% |
| 7527.68 | 6 | 0.1% |
| 7501.96 | 14 |
Discount
Real number (ℝ)
High correlation  Zeros 
| Distinct | 162 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1539.0243 |
| Minimum | 0 |
|---|---|
| Maximum | 4800 |
| Zeros | 1176 |
| Zeros (%) | 20.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 45.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1120 |
| median | 1548 |
| Q3 | 2112 |
| 95-th percentile | 3290 |
| Maximum | 4800 |
| Range | 4800 |
| Interquartile range (IQR) | 992 |
Descriptive statistics
| Standard deviation | 1033.9396 |
|---|---|
| Coefficient of variation (CV) | 0.67181499 |
| Kurtosis | -0.35090255 |
| Mean | 1539.0243 |
| Median Absolute Deviation (MAD) | 564 |
| Skewness | 0.10588915 |
| Sum | 9018682.1 |
| Variance | 1069031 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1176 | 20.1% |
| 2600 | 278 | 4.7% |
| 1700 | 278 | 4.7% |
| 2112 | 249 | 4.2% |
| 2016 | 168 | 2.9% |
| 1480 | 143 | 2.4% |
| 1980 | 130 | 2.2% |
| 1560 | 121 | 2.1% |
| 1210 | 114 | 1.9% |
| 1190 | 110 | 1.9% |
| Other values (152) | 3093 |
| Value | Count | Frequency (%) |
| 0 | 1176 | |
| 48.64 | 1 | < 0.1% |
| 76.7 | 1 | < 0.1% |
| 78.83 | 1 | < 0.1% |
| 80 | 82 | 1.4% |
| 135.73 | 1 | < 0.1% |
| 151.59 | 1 | < 0.1% |
| 175 | 2 | < 0.1% |
| 206.53 | 1 | < 0.1% |
| 217.06 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 4800 | 4 | 0.1% |
| 4410 | 22 | |
| 4340 | 39 | |
| 4200 | 3 | 0.1% |
| 4000 | 5 | 0.1% |
| 3738 | 8 | 0.1% |
| 3660 | 4 | 0.1% |
| 3600 | 6 | 0.1% |
| 3560 | 8 | 0.1% |
| 3540 | 12 | 0.2% |
GST Tax Type Code
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1591 |
| Missing (%) | 27.2% |
| Memory size | 358.0 KiB |
| GST12 |
|---|
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | GST12 |
|---|---|
| 2nd row | GST12 |
| 3rd row | GST12 |
| 4th row | GST12 |
| 5th row | GST12 |
Common Values
| Value | Count | Frequency (%) |
| GST12 | 4269 | |
| (Missing) | 1591 | 27.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| gst12 | 4269 |
Most occurring characters
| Value | Count | Frequency (%) |
| G | 4269 | |
| S | 4269 | |
| T | 4269 | |
| 1 | 4269 | |
| 2 | 4269 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 12807 | |
| Decimal Number | 8538 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 4269 | |
| S | 4269 | |
| T | 4269 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 4269 | |
| 2 | 4269 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12807 | |
| Common | 8538 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| G | 4269 | |
| S | 4269 | |
| T | 4269 |
Common
| Value | Count | Frequency (%) |
| 1 | 4269 | |
| 2 | 4269 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 21345 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| G | 4269 | |
| S | 4269 | |
| T | 4269 | |
| 1 | 4269 | |
| 2 | 4269 |
CGST
Real number (ℝ)
High correlation  Zeros 
| Distinct | 177 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.502348 |
| Minimum | 0 |
|---|---|
| Maximum | 400.66 |
| Zeros | 4926 |
| Zeros (%) | 84.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 45.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 209.94 |
| Maximum | 400.66 |
| Range | 400.66 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 70.832179 |
|---|---|
| Coefficient of variation (CV) | 2.4008997 |
| Kurtosis | 3.9107197 |
| Mean | 29.502348 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.2410892 |
| Sum | 172883.76 |
| Variance | 5017.1976 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4926 | |
| 176.73 | 57 | 1.0% |
| 208.88 | 50 | 0.9% |
| 240.38 | 48 | 0.8% |
| 134.94 | 31 | 0.5% |
| 229.44 | 25 | 0.4% |
| 167.52 | 23 | 0.4% |
| 171.38 | 22 | 0.4% |
| 151.98 | 21 | 0.4% |
| 183.16 | 18 | 0.3% |
| Other values (167) | 639 | 10.9% |
| Value | Count | Frequency (%) |
| 0 | 4926 | |
| 20.93 | 1 | < 0.1% |
| 67.12 | 1 | < 0.1% |
| 67.18 | 1 | < 0.1% |
| 70.66 | 4 | 0.1% |
| 73.88 | 1 | < 0.1% |
| 76.44 | 1 | < 0.1% |
| 77.09 | 4 | 0.1% |
| 77.14 | 1 | < 0.1% |
| 79.44 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 400.66 | 13 | |
| 321.38 | 2 | < 0.1% |
| 299.94 | 1 | < 0.1% |
| 286.07 | 1 | < 0.1% |
| 286.02 | 2 | < 0.1% |
| 278.57 | 1 | < 0.1% |
| 276.48 | 2 | < 0.1% |
| 267.8 | 1 | < 0.1% |
| 257.14 | 8 | |
| 257.09 | 6 |
IGST
Real number (ℝ)
High correlation  Zeros 
| Distinct | 273 |
|---|---|
| Distinct (%) | 4.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 307.90994 |
| Minimum | 0 |
|---|---|
| Maximum | 964.18 |
| Zeros | 934 |
| Zeros (%) | 15.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 45.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 254.89 |
| median | 335.14 |
| Q3 | 437.04 |
| 95-th percentile | 494.89 |
| Maximum | 964.18 |
| Range | 964.18 |
| Interquartile range (IQR) | 182.15 |
Descriptive statistics
| Standard deviation | 161.22802 |
|---|---|
| Coefficient of variation (CV) | 0.5236207 |
| Kurtosis | -0.030473274 |
| Mean | 307.90994 |
| Median Absolute Deviation (MAD) | 87.75 |
| Skewness | -0.66341944 |
| Sum | 1804352.2 |
| Variance | 25994.473 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 934 | 15.9% |
| 353.46 | 221 | 3.8% |
| 417.75 | 220 | 3.8% |
| 269.89 | 207 | 3.5% |
| 480.75 | 199 | 3.4% |
| 458.89 | 143 | 2.4% |
| 247.39 | 116 | 2.0% |
| 459.54 | 99 | 1.7% |
| 451.18 | 92 | 1.6% |
| 291.32 | 88 | 1.5% |
| Other values (263) | 3541 |
| Value | Count | Frequency (%) |
| 0 | 934 | |
| 47.9 | 2 | < 0.1% |
| 49.76 | 1 | < 0.1% |
| 128.46 | 2 | < 0.1% |
| 128.57 | 1 | < 0.1% |
| 134.25 | 5 | 0.1% |
| 134.36 | 3 | 0.1% |
| 141.32 | 30 | 0.5% |
| 141.43 | 11 | 0.2% |
| 147.75 | 6 | 0.1% |
| Value | Count | Frequency (%) |
| 964.18 | 1 | < 0.1% |
| 824.89 | 4 | 0.1% |
| 801.43 | 2 | < 0.1% |
| 801.32 | 21 | |
| 749.89 | 1 | < 0.1% |
| 696.32 | 1 | < 0.1% |
| 667.5 | 1 | < 0.1% |
| 642.75 | 1 | < 0.1% |
| 599.89 | 2 | < 0.1% |
| 578.46 | 1 | < 0.1% |
SGST
Real number (ℝ)
High correlation  Zeros 
| Distinct | 177 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.502348 |
| Minimum | 0 |
|---|---|
| Maximum | 400.66 |
| Zeros | 4926 |
| Zeros (%) | 84.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 45.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 209.94 |
| Maximum | 400.66 |
| Range | 400.66 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 70.832179 |
|---|---|
| Coefficient of variation (CV) | 2.4008997 |
| Kurtosis | 3.9107197 |
| Mean | 29.502348 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.2410892 |
| Sum | 172883.76 |
| Variance | 5017.1976 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4926 | |
| 176.73 | 57 | 1.0% |
| 208.88 | 50 | 0.9% |
| 240.38 | 48 | 0.8% |
| 134.94 | 31 | 0.5% |
| 229.44 | 25 | 0.4% |
| 167.52 | 23 | 0.4% |
| 171.38 | 22 | 0.4% |
| 151.98 | 21 | 0.4% |
| 183.16 | 18 | 0.3% |
| Other values (167) | 639 | 10.9% |
| Value | Count | Frequency (%) |
| 0 | 4926 | |
| 20.93 | 1 | < 0.1% |
| 67.12 | 1 | < 0.1% |
| 67.18 | 1 | < 0.1% |
| 70.66 | 4 | 0.1% |
| 73.88 | 1 | < 0.1% |
| 76.44 | 1 | < 0.1% |
| 77.09 | 4 | 0.1% |
| 77.14 | 1 | < 0.1% |
| 79.44 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 400.66 | 13 | |
| 321.38 | 2 | < 0.1% |
| 299.94 | 1 | < 0.1% |
| 286.07 | 1 | < 0.1% |
| 286.02 | 2 | < 0.1% |
| 278.57 | 1 | < 0.1% |
| 276.48 | 2 | < 0.1% |
| 267.8 | 1 | < 0.1% |
| 257.14 | 8 | |
| 257.09 | 6 |
UTGST
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 332.0 KiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 5860 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 5860 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5860 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5860 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 5860 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5860 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 5860 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5860 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 5860 |
CESS
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 332.0 KiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 5860 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 5860 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5860 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5860 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 5860 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5860 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 5860 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5860 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 5860 |
CGST Rate
Categorical
High correlation  Imbalance 
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 343.5 KiB |
| 0.0 | |
|---|---|
| 6.0 | |
| 2.5 | 1 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 6.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 4926 | |
| 6.0 | 933 | 15.9% |
| 2.5 | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 4926 | |
| 6.0 | 933 | 15.9% |
| 2.5 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 10785 | |
| . | 5860 | |
| 6 | 933 | 5.3% |
| 2 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 11720 | |
| Other Punctuation | 5860 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 10785 | |
| 6 | 933 | 8.0% |
| 2 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 5860 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 17580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 10785 | |
| . | 5860 | |
| 6 | 933 | 5.3% |
| 2 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 10785 | |
| . | 5860 | |
| 6 | 933 | 5.3% |
| 2 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
IGST Rate
Categorical
High correlation  Imbalance 
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 336.9 KiB |
| 12 | |
|---|---|
| 0 | |
| 5 | 3 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 1.8401024 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 12 |
| 3rd row | 12 |
| 4th row | 12 |
| 5th row | 12 |
Common Values
| Value | Count | Frequency (%) |
| 12 | 4923 | |
| 0 | 934 | 15.9% |
| 5 | 3 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 12 | 4923 | |
| 0 | 934 | 15.9% |
| 5 | 3 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 4923 | |
| 2 | 4923 | |
| 0 | 934 | 8.7% |
| 5 | 3 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 10783 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 4923 | |
| 2 | 4923 | |
| 0 | 934 | 8.7% |
| 5 | 3 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 10783 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 4923 | |
| 2 | 4923 | |
| 0 | 934 | 8.7% |
| 5 | 3 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10783 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 4923 | |
| 2 | 4923 | |
| 0 | 934 | 8.7% |
| 5 | 3 | < 0.1% |
SGST Rate
Categorical
High correlation  Imbalance 
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 343.5 KiB |
| 0.0 | |
|---|---|
| 6.0 | |
| 2.5 | 1 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 6.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 4926 | |
| 6.0 | 933 | 15.9% |
| 2.5 | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 4926 | |
| 6.0 | 933 | 15.9% |
| 2.5 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 10785 | |
| . | 5860 | |
| 6 | 933 | 5.3% |
| 2 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 11720 | |
| Other Punctuation | 5860 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 10785 | |
| 6 | 933 | 8.0% |
| 2 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 5860 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 17580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 10785 | |
| . | 5860 | |
| 6 | 933 | 5.3% |
| 2 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 10785 | |
| . | 5860 | |
| 6 | 933 | 5.3% |
| 2 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
UTGST Rate
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 332.0 KiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 5860 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 5860 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5860 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5860 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 5860 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5860 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 5860 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5860 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 5860 |
CESS Rate
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 332.0 KiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 5860 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 5860 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5860 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5860 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 5860 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5860 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 5860 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5860 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 5860 |
Sale Order Status
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 372.1 KiB |
| COMPLETE |
|---|
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | COMPLETE |
|---|---|
| 2nd row | COMPLETE |
| 3rd row | COMPLETE |
| 4th row | COMPLETE |
| 5th row | COMPLETE |
Common Values
| Value | Count | Frequency (%) |
| COMPLETE | 5860 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| complete | 5860 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 11720 | |
| C | 5860 | |
| O | 5860 | |
| M | 5860 | |
| P | 5860 | |
| L | 5860 | |
| T | 5860 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 46880 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 11720 | |
| C | 5860 | |
| O | 5860 | |
| M | 5860 | |
| P | 5860 | |
| L | 5860 | |
| T | 5860 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 46880 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 11720 | |
| C | 5860 | |
| O | 5860 | |
| M | 5860 | |
| P | 5860 | |
| L | 5860 | |
| T | 5860 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 46880 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 11720 | |
| C | 5860 | |
| O | 5860 | |
| M | 5860 | |
| P | 5860 | |
| L | 5860 | |
| T | 5860 |
GSTIN
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 412.2 KiB |
| 09AAICN9819MIZL |
|---|
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 15 |
| Min length | 15 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 09AAICN9819MIZL |
|---|---|
| 2nd row | 09AAICN9819MIZL |
| 3rd row | 09AAICN9819MIZL |
| 4th row | 09AAICN9819MIZL |
| 5th row | 09AAICN9819MIZL |
Common Values
| Value | Count | Frequency (%) |
| 09AAICN9819MIZL | 5860 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 09aaicn9819mizl | 5860 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 17580 | |
| A | 11720 | |
| I | 11720 | |
| 0 | 5860 | 6.7% |
| C | 5860 | 6.7% |
| N | 5860 | 6.7% |
| 8 | 5860 | 6.7% |
| 1 | 5860 | 6.7% |
| M | 5860 | 6.7% |
| Z | 5860 | 6.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 52740 | |
| Decimal Number | 35160 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 11720 | |
| I | 11720 | |
| C | 5860 | |
| N | 5860 | |
| M | 5860 | |
| Z | 5860 | |
| L | 5860 |
Decimal Number
| Value | Count | Frequency (%) |
| 9 | 17580 | |
| 0 | 5860 | 16.7% |
| 8 | 5860 | 16.7% |
| 1 | 5860 | 16.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 52740 | |
| Common | 35160 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 11720 | |
| I | 11720 | |
| C | 5860 | |
| N | 5860 | |
| M | 5860 | |
| Z | 5860 | |
| L | 5860 |
Common
| Value | Count | Frequency (%) |
| 9 | 17580 | |
| 0 | 5860 | 16.7% |
| 8 | 5860 | 16.7% |
| 1 | 5860 | 16.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 87900 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 9 | 17580 | |
| A | 11720 | |
| I | 11720 | |
| 0 | 5860 | 6.7% |
| C | 5860 | 6.7% |
| N | 5860 | 6.7% |
| 8 | 5860 | 6.7% |
| 1 | 5860 | 6.7% |
| M | 5860 | 6.7% |
| Z | 5860 | 6.7% |
SKU Name
Text
| Distinct | 91 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 639.7 KiB |
Length
| Max length | 89 |
|---|---|
| Median length | 77 |
| Mean length | 54.766041 |
| Min length | 18 |
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Women Panelled Gotta Patti Chanderi Silk Kurta with Palazzos & With Dupatta |
|---|---|
| 2nd row | Ethnic Motifs Yoke Design Gotta Patti Chanderi Silk Kurta with Churidar & Dupatta |
| 3rd row | Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta |
| 4th row | Leheriya Embroidered Empire Beads and Stones Silk Crepe Kurta Churidar & Dupatta |
| 5th row | Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatta |
| Value | Count | Frequency (%) |
| with | 6046 | 12.7% |
| kurta | 3423 | 7.2% |
| 2900 | 6.1% | |
| dupatta | 2725 | 5.7% |
| embroidered | 1970 | 4.1% |
| women | 1864 | 3.9% |
| churidar | 1857 | 3.9% |
| regular | 1494 | 3.1% |
| ethnic | 1025 | 2.1% |
| sequinned | 957 | 2.0% |
| Other values (94) | 23469 |
Most occurring characters
| Value | Count | Frequency (%) |
| 41870 | 13.0% | |
| r | 25494 | 7.9% |
| t | 24652 | 7.7% |
| a | 24399 | 7.6% |
| e | 23982 | 7.5% |
| i | 20749 | 6.5% |
| o | 14730 | 4.6% |
| u | 13561 | 4.2% |
| d | 12746 | 4.0% |
| h | 12224 | 3.8% |
| Other values (42) | 106522 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 230976 | |
| Uppercase Letter | 43374 | 13.5% |
| Space Separator | 41870 | 13.0% |
| Other Punctuation | 2903 | 0.9% |
| Dash Punctuation | 1603 | 0.5% |
| Decimal Number | 203 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 25494 | |
| t | 24652 | |
| a | 24399 | |
| e | 23982 | |
| i | 20749 | |
| o | 14730 | 6.4% |
| u | 13561 | 5.9% |
| d | 12746 | 5.5% |
| h | 12224 | 5.3% |
| n | 11731 | 5.1% |
| Other values (15) | 46708 |
Uppercase Letter
| Value | Count | Frequency (%) |
| W | 6644 | |
| C | 5130 | |
| D | 4088 | |
| S | 3983 | |
| E | 3743 | |
| K | 3592 | |
| P | 3378 | |
| T | 2560 | 5.9% |
| R | 1926 | 4.4% |
| O | 1087 | 2.5% |
| Other values (12) | 7243 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 2900 | |
| , | 3 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 41870 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1603 |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 203 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 274350 | |
| Common | 46579 | 14.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 25494 | 9.3% |
| t | 24652 | 9.0% |
| a | 24399 | 8.9% |
| e | 23982 | 8.7% |
| i | 20749 | 7.6% |
| o | 14730 | 5.4% |
| u | 13561 | 4.9% |
| d | 12746 | 4.6% |
| h | 12224 | 4.5% |
| n | 11731 | 4.3% |
| Other values (37) | 90082 |
Common
| Value | Count | Frequency (%) |
| 41870 | ||
| & | 2900 | 6.2% |
| - | 1603 | 3.4% |
| 3 | 203 | 0.4% |
| , | 3 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 320929 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 41870 | 13.0% | |
| r | 25494 | 7.9% |
| t | 24652 | 7.7% |
| a | 24399 | 7.6% |
| e | 23982 | 7.5% |
| i | 20749 | 6.5% |
| o | 14730 | 4.6% |
| u | 13561 | 4.2% |
| d | 12746 | 4.0% |
| h | 12224 | 3.8% |
| Other values (42) | 106522 |
Seller SKU Code
Text
| Distinct | 490 |
|---|---|
| Distinct (%) | 8.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 393.4 KiB |
Length
| Max length | 17 |
|---|---|
| Median length | 16 |
| Mean length | 11.723891 |
| Min length | 9 |
Unique
| Unique | 87 ? |
|---|---|
| Unique (%) | 1.5% |
Sample
| 1st row | ADGRN035-M |
|---|---|
| 2nd row | ADKSET151-2XL |
| 3rd row | ADKSET147-L |
| 4th row | ADYLW036-S |
| 5th row | ADKSET261-L |
| Value | Count | Frequency (%) |
| adcrdset159-s | 125 | 2.1% |
| adcrdset159-m | 120 | 2.0% |
| adkset148-m | 87 | 1.5% |
| adcrdset159-l | 83 | 1.4% |
| adkset157-s | 81 | 1.4% |
| adkset157-m | 81 | 1.4% |
| adcrdset159-xs | 81 | 1.4% |
| adkset261-s | 80 | 1.4% |
| adjmp145-s | 76 | 1.3% |
| adkset148-l | 73 | 1.2% |
| Other values (480) | 4973 |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 7450 | 10.8% |
| A | 6779 | 9.9% |
| S | 6292 | 9.2% |
| - | 5921 | 8.6% |
| 1 | 4431 | 6.4% |
| T | 4149 | 6.0% |
| E | 3880 | 5.6% |
| L | 3021 | 4.4% |
| K | 2729 | 4.0% |
| 2 | 2644 | 3.8% |
| Other values (23) | 21406 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 44859 | |
| Decimal Number | 17922 | 26.1% |
| Dash Punctuation | 5921 | 8.6% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 7450 | |
| A | 6779 | |
| S | 6292 | |
| T | 4149 | |
| E | 3880 | |
| L | 3021 | |
| K | 2729 | 6.1% |
| X | 2202 | 4.9% |
| M | 1809 | 4.0% |
| R | 1796 | 4.0% |
| Other values (12) | 4752 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 4431 | |
| 2 | 2644 | |
| 0 | 2333 | |
| 5 | 1981 | |
| 6 | 1598 | 8.9% |
| 4 | 1492 | 8.3% |
| 7 | 1019 | 5.7% |
| 8 | 875 | 4.9% |
| 9 | 855 | 4.8% |
| 3 | 694 | 3.9% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5921 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 44859 | |
| Common | 23843 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| D | 7450 | |
| A | 6779 | |
| S | 6292 | |
| T | 4149 | |
| E | 3880 | |
| L | 3021 | |
| K | 2729 | 6.1% |
| X | 2202 | 4.9% |
| M | 1809 | 4.0% |
| R | 1796 | 4.0% |
| Other values (12) | 4752 |
Common
| Value | Count | Frequency (%) |
| - | 5921 | |
| 1 | 4431 | |
| 2 | 2644 | |
| 0 | 2333 | 9.8% |
| 5 | 1981 | 8.3% |
| 6 | 1598 | 6.7% |
| 4 | 1492 | 6.3% |
| 7 | 1019 | 4.3% |
| 8 | 875 | 3.7% |
| 9 | 855 | 3.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 68702 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| D | 7450 | 10.8% |
| A | 6779 | 9.9% |
| S | 6292 | 9.2% |
| - | 5921 | 8.6% |
| 1 | 4431 | 6.4% |
| T | 4149 | 6.0% |
| E | 3880 | 5.6% |
| L | 3021 | 4.4% |
| K | 2729 | 4.0% |
| 2 | 2644 | 3.8% |
| Other values (23) | 21406 |
Shipping Courier Status
Categorical
High correlation  Imbalance  Missing 
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 98 |
| Missing (%) | 1.7% |
| Memory size | 390.8 KiB |
| DELIVERED | |
|---|---|
| COURIER_RETURN-DELIVERED | |
| COURIER_RETURN-RTO-DELIVERED | 156 |
| SHIPPED | 69 |
| COURIER_RETURN-CONFIRMED | 22 |
| Other values (5) | 21 |
Length
| Max length | 28 |
|---|---|
| Median length | 9 |
| Mean length | 11.333565 |
| Min length | 7 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | DELIVERED |
|---|---|
| 2nd row | DELIVERED |
| 3rd row | DELIVERED |
| 4th row | DELIVERED |
| 5th row | DELIVERED |
Common Values
| Value | Count | Frequency (%) |
| DELIVERED | 4815 | |
| COURIER_RETURN-DELIVERED | 679 | 11.6% |
| COURIER_RETURN-RTO-DELIVERED | 156 | 2.7% |
| SHIPPED | 69 | 1.2% |
| COURIER_RETURN-CONFIRMED | 22 | 0.4% |
| OUTFORDELIVERY | 9 | 0.2% |
| INTRANSIT | 7 | 0.1% |
| SHIPMENTHELD | 2 | < 0.1% |
| COURIER_RETURN-RTO-INTRANSIT | 2 | < 0.1% |
| COURIER_RETURN-RTO-FAILED | 1 | < 0.1% |
| (Missing) | 98 | 1.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| delivered | 4815 | |
| courier_return-delivered | 679 | 11.8% |
| courier_return-rto-delivered | 156 | 2.7% |
| shipped | 69 | 1.2% |
| courier_return-confirmed | 22 | 0.4% |
| outfordelivery | 9 | 0.2% |
| intransit | 7 | 0.1% |
| shipmentheld | 2 | < 0.1% |
| courier_return-rto-intransit | 2 | < 0.1% |
| courier_return-rto-failed | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 18784 | |
| D | 11403 | |
| R | 9298 | |
| I | 6631 | 10.2% |
| L | 5662 | 8.7% |
| V | 5659 | 8.7% |
| U | 1729 | 2.6% |
| O | 1059 | 1.6% |
| T | 1048 | 1.6% |
| - | 1019 | 1.6% |
| Other values (10) | 3012 | 4.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 63425 | |
| Dash Punctuation | 1019 | 1.6% |
| Connector Punctuation | 860 | 1.3% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 18784 | |
| D | 11403 | |
| R | 9298 | |
| I | 6631 | 10.5% |
| L | 5662 | 8.9% |
| V | 5659 | 8.9% |
| U | 1729 | 2.7% |
| O | 1059 | 1.7% |
| T | 1048 | 1.7% |
| N | 902 | 1.4% |
| Other values (8) | 1250 | 2.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1019 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 860 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 63425 | |
| Common | 1879 | 2.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 18784 | |
| D | 11403 | |
| R | 9298 | |
| I | 6631 | 10.5% |
| L | 5662 | 8.9% |
| V | 5659 | 8.9% |
| U | 1729 | 2.7% |
| O | 1059 | 1.7% |
| T | 1048 | 1.7% |
| N | 902 | 1.4% |
| Other values (8) | 1250 | 2.0% |
Common
| Value | Count | Frequency (%) |
| - | 1019 | |
| _ | 860 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 65304 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 18784 | |
| D | 11403 | |
| R | 9298 | |
| I | 6631 | 10.2% |
| L | 5662 | 8.7% |
| V | 5659 | 8.7% |
| U | 1729 | 2.6% |
| O | 1059 | 1.6% |
| T | 1048 | 1.6% |
| - | 1019 | 1.6% |
| Other values (10) | 3012 | 4.6% |
Shipping Tracking Status
Categorical
High correlation  Missing 
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 98 |
| Missing (%) | 1.7% |
| Memory size | 423.3 KiB |
| STATUS_NOT_DEFINED | |
|---|---|
| DELIVERED | |
| RTO_DELIVERED_TO_SELLER | |
| RTO_INITIATED | 22 |
| PENDING_IN_TRANSIT | 16 |
Length
| Max length | 23 |
|---|---|
| Median length | 18 |
| Mean length | 17.112808 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | DELIVERED |
|---|---|
| 2nd row | DELIVERED |
| 3rd row | DELIVERED |
| 4th row | STATUS_NOT_DEFINED |
| 5th row | STATUS_NOT_DEFINED |
Common Values
| Value | Count | Frequency (%) |
| STATUS_NOT_DEFINED | 4112 | |
| DELIVERED | 933 | 15.9% |
| RTO_DELIVERED_TO_SELLER | 679 | 11.6% |
| RTO_INITIATED | 22 | 0.4% |
| PENDING_IN_TRANSIT | 16 | 0.3% |
| (Missing) | 98 | 1.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| status_not_defined | 4112 | |
| delivered | 933 | 16.2% |
| rto_delivered_to_seller | 679 | 11.8% |
| rto_initiated | 22 | 0.4% |
| pending_in_transit | 16 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 14456 | |
| T | 13792 | |
| D | 11486 | |
| _ | 10315 | |
| S | 8919 | |
| N | 8310 | |
| I | 5838 | |
| O | 5492 | 5.6% |
| A | 4150 | 4.2% |
| U | 4112 | 4.2% |
| Other values (6) | 11734 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 88289 | |
| Connector Punctuation | 10315 | 10.5% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 14456 | |
| T | 13792 | |
| D | 11486 | |
| S | 8919 | |
| N | 8310 | |
| I | 5838 | |
| O | 5492 | 6.2% |
| A | 4150 | 4.7% |
| U | 4112 | 4.7% |
| F | 4112 | 4.7% |
| Other values (5) | 7622 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 10315 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 88289 | |
| Common | 10315 | 10.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 14456 | |
| T | 13792 | |
| D | 11486 | |
| S | 8919 | |
| N | 8310 | |
| I | 5838 | |
| O | 5492 | 6.2% |
| A | 4150 | 4.7% |
| U | 4112 | 4.7% |
| F | 4112 | 4.7% |
| Other values (5) | 7622 |
Common
| Value | Count | Frequency (%) |
| _ | 10315 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 98604 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 14456 | |
| T | 13792 | |
| D | 11486 | |
| _ | 10315 | |
| S | 8919 | |
| N | 8310 | |
| I | 5838 | |
| O | 5492 | 5.6% |
| A | 4150 | 4.2% |
| U | 4112 | 4.2% |
| Other values (6) | 11734 |
Interactions
Correlations
| Billing Address Id | Billing Address Pincode | Billing Address State | CGST | CGST Rate | Channel Name | Discount | IGST | IGST Rate | Item Type Color | MRP | Prepaid Amount | SGST | SGST Rate | Selling Price | Shipping Address Id | Shipping Address Pincode | Shipping Address State | Shipping Courier Status | Shipping Tracking Status | Subtotal | Total Price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Billing Address Id | 1.000 | 0.013 | 0.076 | 0.023 | 0.059 | 0.134 | 0.172 | 0.071 | 0.057 | 0.155 | 0.164 | -0.068 | 0.023 | 0.059 | 0.126 | 1.000 | 0.013 | 0.076 | 0.091 | 0.119 | 0.173 | 0.126 |
| Billing Address Pincode | 0.013 | 1.000 | 0.878 | -0.318 | 0.637 | 0.031 | 0.021 | 0.151 | 0.638 | 0.057 | -0.034 | -0.035 | -0.318 | 0.637 | -0.063 | 0.013 | 1.000 | 0.878 | 0.026 | 0.024 | -0.024 | -0.063 |
| Billing Address State | 0.076 | 0.878 | 1.000 | 0.324 | 0.702 | 0.091 | 0.053 | 0.335 | 0.703 | 0.116 | 0.041 | 0.000 | 0.324 | 0.702 | 0.026 | 0.076 | 0.878 | 1.000 | 0.046 | 0.063 | 0.066 | 0.026 |
| CGST | 0.023 | -0.318 | 0.324 | 1.000 | 0.706 | 0.098 | 0.038 | -0.632 | 0.706 | 0.320 | 0.047 | -0.020 | 1.000 | 0.706 | 0.043 | 0.023 | -0.318 | 0.324 | 0.000 | 0.034 | 0.049 | 0.043 |
| CGST Rate | 0.059 | 0.637 | 0.702 | 0.706 | 1.000 | 0.005 | 0.266 | 0.705 | 0.707 | 0.039 | 0.353 | 0.000 | 0.706 | 1.000 | 0.057 | 0.059 | 0.637 | 0.702 | 0.080 | 0.000 | 0.116 | 0.057 |
| Channel Name | 0.134 | 0.031 | 0.091 | 0.098 | 0.005 | 1.000 | 0.951 | 0.138 | 0.006 | 0.184 | 0.144 | 0.697 | 0.098 | 0.005 | 0.107 | 0.134 | 0.031 | 0.091 | 0.390 | 0.874 | 0.697 | 0.107 |
| Discount | 0.172 | 0.021 | 0.053 | 0.038 | 0.266 | 0.951 | 1.000 | 0.128 | 0.308 | 0.496 | 0.472 | -0.490 | 0.038 | 0.266 | 0.215 | 0.172 | 0.021 | 0.053 | 0.126 | 0.416 | 0.833 | 0.215 |
| IGST | 0.071 | 0.151 | 0.335 | -0.632 | 0.705 | 0.138 | 0.128 | 1.000 | 0.706 | 0.552 | 0.548 | -0.000 | -0.632 | 0.705 | 0.707 | 0.071 | 0.151 | 0.335 | 0.058 | 0.083 | 0.456 | 0.707 |
| IGST Rate | 0.057 | 0.638 | 0.703 | 0.706 | 0.707 | 0.006 | 0.308 | 0.706 | 1.000 | 0.039 | 0.612 | 0.084 | 0.706 | 0.707 | 0.102 | 0.057 | 0.638 | 0.703 | 0.000 | 0.000 | 0.201 | 0.102 |
| Item Type Color | 0.155 | 0.057 | 0.116 | 0.320 | 0.039 | 0.184 | 0.496 | 0.552 | 0.039 | 1.000 | 0.611 | 0.146 | 0.320 | 0.039 | 0.702 | 0.155 | 0.057 | 0.116 | 0.079 | 0.150 | 0.491 | 0.702 |
| MRP | 0.164 | -0.034 | 0.041 | 0.047 | 0.353 | 0.144 | 0.472 | 0.548 | 0.612 | 0.611 | 1.000 | -0.003 | 0.047 | 0.353 | 0.788 | 0.164 | -0.034 | 0.041 | 0.042 | 0.060 | 0.772 | 0.788 |
| Prepaid Amount | -0.068 | -0.035 | 0.000 | -0.020 | 0.000 | 0.697 | -0.490 | -0.000 | 0.084 | 0.146 | -0.003 | 1.000 | -0.020 | 0.000 | -0.028 | -0.068 | -0.035 | 0.000 | 0.051 | 0.364 | -0.400 | -0.028 |
| SGST | 0.023 | -0.318 | 0.324 | 1.000 | 0.706 | 0.098 | 0.038 | -0.632 | 0.706 | 0.320 | 0.047 | -0.020 | 1.000 | 0.706 | 0.043 | 0.023 | -0.318 | 0.324 | 0.000 | 0.034 | 0.049 | 0.043 |
| SGST Rate | 0.059 | 0.637 | 0.702 | 0.706 | 1.000 | 0.005 | 0.266 | 0.705 | 0.707 | 0.039 | 0.353 | 0.000 | 0.706 | 1.000 | 0.057 | 0.059 | 0.637 | 0.702 | 0.080 | 0.000 | 0.116 | 0.057 |
| Selling Price | 0.126 | -0.063 | 0.026 | 0.043 | 0.057 | 0.107 | 0.215 | 0.707 | 0.102 | 0.702 | 0.788 | -0.028 | 0.043 | 0.057 | 1.000 | 0.126 | -0.063 | 0.026 | 0.043 | 0.040 | 0.667 | 1.000 |
| Shipping Address Id | 1.000 | 0.013 | 0.076 | 0.023 | 0.059 | 0.134 | 0.172 | 0.071 | 0.057 | 0.155 | 0.164 | -0.068 | 0.023 | 0.059 | 0.126 | 1.000 | 0.013 | 0.076 | 0.091 | 0.119 | 0.173 | 0.126 |
| Shipping Address Pincode | 0.013 | 1.000 | 0.878 | -0.318 | 0.637 | 0.031 | 0.021 | 0.151 | 0.638 | 0.057 | -0.034 | -0.035 | -0.318 | 0.637 | -0.063 | 0.013 | 1.000 | 0.878 | 0.026 | 0.024 | -0.024 | -0.063 |
| Shipping Address State | 0.076 | 0.878 | 1.000 | 0.324 | 0.702 | 0.091 | 0.053 | 0.335 | 0.703 | 0.116 | 0.041 | 0.000 | 0.324 | 0.702 | 0.026 | 0.076 | 0.878 | 1.000 | 0.046 | 0.063 | 0.066 | 0.026 |
| Shipping Courier Status | 0.091 | 0.026 | 0.046 | 0.000 | 0.080 | 0.390 | 0.126 | 0.058 | 0.000 | 0.079 | 0.042 | 0.051 | 0.000 | 0.080 | 0.043 | 0.091 | 0.026 | 0.046 | 1.000 | 0.867 | 0.099 | 0.043 |
| Shipping Tracking Status | 0.119 | 0.024 | 0.063 | 0.034 | 0.000 | 0.874 | 0.416 | 0.083 | 0.000 | 0.150 | 0.060 | 0.364 | 0.034 | 0.000 | 0.040 | 0.119 | 0.024 | 0.063 | 0.867 | 1.000 | 0.299 | 0.040 |
| Subtotal | 0.173 | -0.024 | 0.066 | 0.049 | 0.116 | 0.697 | 0.833 | 0.456 | 0.201 | 0.491 | 0.772 | -0.400 | 0.049 | 0.116 | 0.667 | 0.173 | -0.024 | 0.066 | 0.099 | 0.299 | 1.000 | 0.667 |
| Total Price | 0.126 | -0.063 | 0.026 | 0.043 | 0.057 | 0.107 | 0.215 | 0.707 | 0.102 | 0.702 | 0.788 | -0.028 | 0.043 | 0.057 | 1.000 | 0.126 | -0.063 | 0.026 | 0.043 | 0.040 | 0.667 | 1.000 |
Missing values
Sample
| Shipping Address Id | Category | Invoice Code | Invoice Created | Shipping Address City | Shipping Address State | Shipping Address Country | Shipping Address Pincode | Billing Address Id | Billing Address City | Billing Address State | Billing Address Country | Billing Address Pincode | Shipping Method | Item SKU Code | Item Type Name | Item Type Color | Channel Name | Gift Wrap | HSN Code | MRP | Total Price | Selling Price | Cost Price | Prepaid Amount | Subtotal | Discount | GST Tax Type Code | CGST | IGST | SGST | UTGST | CESS | CGST Rate | IGST Rate | SGST Rate | UTGST Rate | CESS Rate | Sale Order Status | GSTIN | SKU Name | Seller SKU Code | Shipping Courier Status | Shipping Tracking Status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 19970813 | Default | NIMAT25F01090 | 31/12/2024 09:45 | Raebareli | Uttar Pradesh | IN | 229001 | 19970814 | Raebareli | Uttar Pradesh | IN | 229001 | STD | ADGRN035-M | Women Panelled Gotta Patti Chanderi Silk Kurta with Palazzos & With Dupatta | Green | NYKAA_FASHION | False | 62045300.0 | 5999.0 | 2700.0 | 2700.0 | NaN | 2670.0 | 2710.72 | 300.0 | NaN | 144.64 | 0.00 | 144.64 | 0 | 0 | 6.0 | 0 | 6.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Women Panelled Gotta Patti Chanderi Silk Kurta with Palazzos & With Dupatta | ADGRN035-M | DELIVERED | DELIVERED |
| 1 | 19984900 | Default | NIMAT25F01091 | 31/12/2024 09:45 | Phagwara | Punjab | IN | 144410 | 19984901 | Phagwara | Punjab | IN | 144410 | STD | ADKSET151-2XL | Ethnic Motifs Yoke Design Gotta Patti Chanderi Silk Kurta with Churidar & Dupatta | NaN | NYKAA_FASHION | False | 62045300.0 | 6599.0 | 4356.0 | 4356.0 | NaN | 0.0 | 3889.29 | 0.0 | GST12 | 0.00 | 466.71 | 0.00 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Ethnic Motifs Yoke Design Gotta Patti Chanderi Silk Kurta with Churidar & Dupatta | ADKSET151-2XL | DELIVERED | DELIVERED |
| 2 | 19986570 | Default | NIMAT25F01092 | 31/12/2024 09:45 | Berhampore | West Bengal | IN | 742122 | 19986571 | Berhampore | West Bengal | IN | 742122 | STD | ADKSET147-L | Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta | Cream | NYKAA_FASHION | False | 62045300.0 | 6999.0 | 3500.0 | 3500.0 | NaN | 0.0 | 3125.00 | 0.0 | NaN | 0.00 | 375.00 | 0.00 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta | ADKSET147-L | DELIVERED | DELIVERED |
| 3 | 19987349 | Default | I0925NC000006459 | 31/12/2024 09:44 | Hyderabad | Telangana | IN | 500075 | 19987349 | Hyderabad | Telangana | IN | 500075 | STD | ADYLW036-S | Leheriya Embroidered Empire Beads and Stones Silk Crepe Kurta Churidar & Dupatta | NaN | MYNTRAPPMP | False | 62045300.0 | 6499.0 | 3639.0 | 3639.0 | NaN | 0.0 | 6109.11 | 2860.0 | GST12 | 0.00 | 389.89 | 0.00 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Leheriya Embroidered Empire Beads and Stones Silk Crepe Kurta Churidar & Dupatta | ADYLW036-S | DELIVERED | STATUS_NOT_DEFINED |
| 4 | 19971790 | Default | I0925NC000006454 | 31/12/2024 09:44 | Kolkata | West Bengal | IN | 700115 | 19971790 | Kolkata | West Bengal | IN | 700115 | STD | ADKSET261-L | Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatta | NaN | MYNTRAPPMP | False | 62045300.0 | 6299.0 | 4283.0 | 4283.0 | NaN | 0.0 | 5840.11 | 2016.0 | GST12 | 0.00 | 458.89 | 0.00 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatta | ADKSET261-L | DELIVERED | STATUS_NOT_DEFINED |
| 5 | 19972169 | Default | I0925NC000006461 | 31/12/2024 09:44 | Jaipur | Rajasthan | IN | 302015 | 19972169 | Jaipur | Rajasthan | IN | 302015 | STD | ADKSET147-XS | Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta | Cream | MYNTRAPPMP | False | 62045300.0 | 6999.0 | 3499.0 | 3499.0 | NaN | 0.0 | 6624.11 | 3500.0 | NaN | 0.00 | 374.89 | 0.00 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta | ADKSET147A-XS | DELIVERED | STATUS_NOT_DEFINED |
| 6 | 19977759 | Default | I0925NC000006462 | 31/12/2024 09:44 | Surat | Gujarat | IN | 395004 | 19977759 | Surat | Gujarat | IN | 395004 | STD | ADCRDSET163-S | Embroidered Round Neck Top With Palazzos | NaN | MYNTRAPPMP | False | 62045300.0 | 5499.0 | 4289.0 | 4289.0 | NaN | 0.0 | 5039.46 | 1210.0 | GST12 | 0.00 | 459.54 | 0.00 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Embroidered Round Neck Top With Palazzos | ADCRDSET163-S | DELIVERED | STATUS_NOT_DEFINED |
| 7 | 19978570 | Default | I0925NC000006453 | 31/12/2024 09:44 | New Delhi | Delhi | IN | 110092 | 19978570 | New Delhi | Delhi | IN | 110092 | STD | ADKSET147-XL | Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta | Cream | MYNTRAPPMP | False | 62045300.0 | 6999.0 | 3499.0 | 3499.0 | NaN | 0.0 | 6624.11 | 3500.0 | NaN | 0.00 | 374.89 | 0.00 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta | ADKSET147A-XL | DELIVERED | STATUS_NOT_DEFINED |
| 8 | 19981812 | Default | I0925NC000006455 | 31/12/2024 09:44 | Surat | Gujarat | IN | 395004 | 19981812 | Surat | Gujarat | IN | 395004 | STD | ADCRDSET159-L | Brocade Co-Ord Set | NaN | MYNTRAPPMP | False | 62045300.0 | 4999.0 | 3299.0 | 3299.0 | NaN | 0.0 | 4645.54 | 1700.0 | GST12 | 0.00 | 353.46 | 0.00 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Brocade Co-Ord Set | ADCRDSET159-L | DELIVERED | STATUS_NOT_DEFINED |
| 9 | 19984011 | Default | I0925NC000006451 | 31/12/2024 09:44 | Gurgaon | Haryana | IN | 122505 | 19984011 | Gurgaon | Haryana | IN | 122505 | STD | ADCRDSET159-XL | Brocade Co-Ord Set | NaN | MYNTRAPPMP | False | 62045300.0 | 4999.0 | 3299.0 | 3299.0 | NaN | 0.0 | 4645.54 | 1700.0 | GST12 | 0.00 | 353.46 | 0.00 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Brocade Co-Ord Set | ADCRDSET159-XL | DELIVERED | STATUS_NOT_DEFINED |
| Shipping Address Id | Category | Invoice Code | Invoice Created | Shipping Address City | Shipping Address State | Shipping Address Country | Shipping Address Pincode | Billing Address Id | Billing Address City | Billing Address State | Billing Address Country | Billing Address Pincode | Shipping Method | Item SKU Code | Item Type Name | Item Type Color | Channel Name | Gift Wrap | HSN Code | MRP | Total Price | Selling Price | Cost Price | Prepaid Amount | Subtotal | Discount | GST Tax Type Code | CGST | IGST | SGST | UTGST | CESS | CGST Rate | IGST Rate | SGST Rate | UTGST Rate | CESS Rate | Sale Order Status | GSTIN | SKU Name | Seller SKU Code | Shipping Courier Status | Shipping Tracking Status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5850 | 17828753 | Default | I0925NC000003789 | 1/10/2024 9:59 | Gautam Buddha Nagar | Uttar Pradesh | IN | 201301 | 17828753 | Gautam Buddha Nagar | Uttar Pradesh | IN | 201301 | STD | ADKSET261-M | Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatta | NaN | MYNTRAPPMP | False | 62045300.0 | 6299.0 | 4283.0 | 4283.0 | NaN | 0.0 | 5840.12 | 2016.0 | GST12 | 229.44 | 0.00 | 229.44 | 0 | 0 | 6.0 | 0 | 6.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatta | ADKSET261-M | COURIER_RETURN-DELIVERED | RTO_DELIVERED_TO_SELLER |
| 5851 | 17829195 | Default | I0925NC000003790 | 1/10/2024 9:59 | Bengaluru | Karnataka | IN | 560069 | 17829195 | Bengaluru | Karnataka | IN | 560069 | STD | ADCRDSET159-XS | Brocade Co-Ord Set | NaN | MYNTRAPPMP | False | 62045300.0 | 4999.0 | 3299.0 | 3299.0 | NaN | 0.0 | 4645.54 | 1700.0 | GST12 | 0.00 | 353.46 | 0.00 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Brocade Co-Ord Set | ADCRDSET159-XS | COURIER_RETURN-DELIVERED | RTO_DELIVERED_TO_SELLER |
| 5852 | 17831361 | Default | I0925NC000003791 | 1/10/2024 9:59 | Kolkata, | West Bengal | IN | 700004 | 17831361 | Kolkata, | West Bengal | IN | 700004 | STD | ADKSET236-L | Women Panelled Kurta with Trousers | Green | MYNTRAPPMP | False | 62045300.0 | 5999.0 | 4079.0 | 4079.0 | NaN | 0.0 | 5561.96 | 1920.0 | NaN | 0.00 | 437.04 | 0.00 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Women Panelled Kurta with Trousers | ADKSET236-L | DELIVERED | STATUS_NOT_DEFINED |
| 5853 | 17831437 | Default | I0925NC000003766 | 1/10/2024 9:59 | Kolkata, | West Bengal | IN | 700004 | 17831437 | Kolkata, | West Bengal | IN | 700004 | STD | ADKSET261-XXL | Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatt | NaN | MYNTRAPPMP | False | 62045300.0 | 6299.0 | 4283.0 | 4283.0 | NaN | 0.0 | 5840.11 | 2016.0 | GST12 | 0.00 | 458.89 | 0.00 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatt | ADKSET261-XXL | DELIVERED | STATUS_NOT_DEFINED |
| 5854 | 17831642 | Default | I0925NC000003778 | 1/10/2024 9:59 | Mumbai | Maharashtra | IN | 400042 | 17831642 | Mumbai | Maharashtra | IN | 400042 | STD | ADKSET261-XXL | Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatt | NaN | MYNTRAPPMP | False | 62045300.0 | 6299.0 | 4283.0 | 4283.0 | NaN | 0.0 | 5840.11 | 2016.0 | GST12 | 0.00 | 458.89 | 0.00 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Women Ethnic Motifs Panelled Sequinned Chanderi Cotton Kurta with Churidar & With Dupatt | ADKSET261-XXL | COURIER_RETURN-DELIVERED | RTO_DELIVERED_TO_SELLER |
| 5855 | 17832698 | Default | I0925NC000003767 | 1/10/2024 9:59 | Jallandhar | Punjab | IN | 144022 | 17832698 | Jallandhar | Punjab | IN | 144022 | STD | ADJMP145-M | Floral Printed Culotte Jumpsuit | NaN | MYNTRAPPMP | False | 62045300.0 | 4599.0 | 3127.0 | 3127.0 | NaN | 0.0 | 4263.96 | 1472.0 | GST12 | 0.00 | 335.04 | 0.00 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Floral Printed Culotte Jumpsuit | ADJMP145-M | DELIVERED | STATUS_NOT_DEFINED |
| 5856 | 17834756 | Default | I0925NC000003793 | 1/10/2024 9:59 | Kolkata | West Bengal | IN | 743144 | 17834756 | Kolkata | West Bengal | IN | 743144 | STD | ADKSET147-XS | Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta | Cream | MYNTRAPPMP | False | 62045300.0 | 6999.0 | 3499.0 | 3499.0 | NaN | 0.0 | 6624.11 | 3500.0 | NaN | 0.00 | 374.89 | 0.00 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Women Embroidered Regular Thread Work Chanderi Cotton Kurta with Churidar & With Dupatta | ADKSET147A-XS | DELIVERED | STATUS_NOT_DEFINED |
| 5857 | 17835046 | Default | I0925NC000003769 | 1/10/2024 9:59 | Nagpur | Maharashtra | IN | 440033 | 17835046 | Nagpur | Maharashtra | IN | 440033 | STD | ADBLU020-M | Woven Design Lapel Collar Jacket and Organza Palazzo | NaN | MYNTRAPPMP | False | 62045300.0 | 6499.0 | 3639.0 | 3639.0 | NaN | 0.0 | 6109.11 | 2860.0 | GST12 | 0.00 | 389.89 | 0.00 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Woven Design Lapel Collar Jacket and Organza Palazzo | ADBLU020-M | DELIVERED | STATUS_NOT_DEFINED |
| 5858 | 17835046 | Default | I0925NC000003769 | 1/10/2024 9:59 | Nagpur | Maharashtra | IN | 440033 | 17835046 | Nagpur | Maharashtra | IN | 440033 | STD | ADBLU020-XL | Woven Design Lapel Collar Jacket and Organza Palazzo | NaN | MYNTRAPPMP | False | 62045300.0 | 6499.0 | 3639.0 | 3639.0 | NaN | 0.0 | 6109.11 | 2860.0 | GST12 | 0.00 | 389.89 | 0.00 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Woven Design Lapel Collar Jacket and Organza Palazzo | ADBLU020-XL | DELIVERED | STATUS_NOT_DEFINED |
| 5859 | 17835851 | Default | I0925NC000003783 | 1/10/2024 9:59 | Kolkata | West Bengal | IN | 700078 | 17835851 | Kolkata | West Bengal | IN | 700078 | STD | ADKSET240-XS | Women High Slit Pure Silk Kurta with Trousers | NaN | MYNTRAPPMP | False | 62045300.0 | 3999.0 | 2719.0 | 2719.0 | NaN | 0.0 | 3707.68 | 1280.0 | GST12 | 0.00 | 291.32 | 0.00 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Women High Slit Pure Silk Kurta with Trousers | ADKSET240-XS | DELIVERED | STATUS_NOT_DEFINED |
Duplicate rows
Most frequently occurring
| Shipping Address Id | Category | Invoice Code | Invoice Created | Shipping Address City | Shipping Address State | Shipping Address Country | Shipping Address Pincode | Billing Address Id | Billing Address City | Billing Address State | Billing Address Country | Billing Address Pincode | Shipping Method | Item SKU Code | Item Type Name | Item Type Color | Channel Name | Gift Wrap | HSN Code | MRP | Total Price | Selling Price | Prepaid Amount | Subtotal | Discount | GST Tax Type Code | CGST | IGST | SGST | UTGST | CESS | CGST Rate | IGST Rate | SGST Rate | UTGST Rate | CESS Rate | Sale Order Status | GSTIN | SKU Name | Seller SKU Code | Shipping Courier Status | Shipping Tracking Status | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 17147660 | Default | I0925NC000003225 | 28/08/2024 09:54 | Jamshedpur | Jharkhand | IN | 832110 | 17147660 | Jamshedpur | Jharkhand | IN | 832110 | STD | ADKSET116-2XL | Ethnic Motifs Regular Chanderi Silk Kurta With Trousers & Dupatta | NaN | MYNTRAPPMP | False | 62045300.0 | 4999.0 | 2899.0 | 2899.0 | 0.0 | 4688.395 | 2100.0 | GST12 | 0.000 | 310.605 | 0.000 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Ethnic Motifs Regular Chanderi Silk Kurta With Trousers & Dupatta | ADKSET116-2XL | DELIVERED | STATUS_NOT_DEFINED | 2 |
| 1 | 17277998 | Default | I0925NC000003342 | 9/4/2024 10:01 | Bhavnagar | Gujarat | IN | 364002 | 17277998 | Bhavnagar | Gujarat | IN | 364002 | STD | ADJMP145-XS | Floral Printed Culotte Jumpsuit | NaN | MYNTRAPPMP | False | 62045300.0 | 4599.0 | 3219.0 | 3219.0 | 0.0 | 4254.105 | 1380.0 | GST12 | 0.000 | 344.895 | 0.000 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Floral Printed Culotte Jumpsuit | ADJMP145-XS | DELIVERED | STATUS_NOT_DEFINED | 2 |
| 2 | 18259525 | Default | I0925NC000004333 | 17/10/2024 10:01 | New Delhi | Delhi | IN | 110043 | 18259525 | New Delhi | Delhi | IN | 110043 | STD | ADCRDSET188-S | Printed Tunic With Trousers | NaN | MYNTRAPPMP | False | 62045300.0 | 2999.0 | 1979.0 | 1979.0 | 0.0 | 2786.965 | 1020.0 | GST12 | 0.000 | 212.035 | 0.000 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Printed Tunic With Trousers | ADCRDSET188-S | COURIER_RETURN-DELIVERED | RTO_DELIVERED_TO_SELLER | 2 |
| 3 | 18398525 | Default | I0925NC000004603 | 22/10/2024 17:36 | Rampur | Uttar Pradesh | IN | 244901 | 18398525 | Rampur | Uttar Pradesh | IN | 244901 | STD | ADKSET161A-L | Women Embroidered High Slit Sequinned Silk Georgette Kurta with Sharara & With Dupatta | Red | MYNTRAPPMP | False | 62045300.0 | NaN | 3709.0 | 3709.0 | 0.0 | 6601.600 | 3290.0 | NaN | 198.700 | 0.000 | 198.700 | 0 | 0 | 6.0 | 0 | 6.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Women Embroidered High Slit Sequinned Silk Georgette Kurta with Sharara & With Dupatta | ADKSET161A-L | DELIVERED | STATUS_NOT_DEFINED | 2 |
| 4 | 18530461 | Default | I0925NC000004899 | 26/10/2024 17:15 | Lucknow | Uttar Pradesh | IN | 226022 | 18530461 | Lucknow | Uttar Pradesh | IN | 226022 | STD | ADCRDSET263-M | Printed Tunic With Palazzzos | NaN | MYNTRAPPMP | False | 62045300.0 | 5999.0 | 4439.0 | 4439.0 | 0.0 | 5523.400 | 1560.0 | GST12 | 237.800 | 0.000 | 237.800 | 0 | 0 | 6.0 | 0 | 6.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Printed Tunic With Palazzzos | ADCRDSET263-M | DELIVERED | STATUS_NOT_DEFINED | 2 |
| 5 | 18634020 | Default | I0925NC000005015 | 30/10/2024 16:53 | Delhi | Delhi | IN | 110093 | 18634020 | Delhi | Delhi | IN | 110093 | STD | ADKSET116-XL | Ethnic Motifs Regular Chanderi Silk Kurta With Trousers & Dupatta | NaN | MYNTRAPPMP | False | 62045300.0 | 4999.0 | 2699.0 | 2699.0 | 0.0 | 4709.820 | 2300.0 | GST12 | 0.000 | 289.180 | 0.000 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Ethnic Motifs Regular Chanderi Silk Kurta With Trousers & Dupatta | ADKSET116-XL | COURIER_RETURN-DELIVERED | RTO_DELIVERED_TO_SELLER | 2 |
| 6 | 18775768 | Default | I0925NC000005198 | 7/11/2024 9:51 | Bhagalpur | Bihar | IN | 812002 | 18775768 | Bhagalpur | Bihar | IN | 812002 | STD | ADKSET161A-XS | Women Embroidered High Slit Sequinned Silk Georgette Kurta with Sharara & With Dupatta | Red | MYNTRAPPMP | False | 62045300.0 | NaN | 3709.0 | 3709.0 | 0.0 | 6601.605 | 3290.0 | NaN | 0.000 | 397.395 | 0.000 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Women Embroidered High Slit Sequinned Silk Georgette Kurta with Sharara & With Dupatta | ADKSET161A-XS | COURIER_RETURN-DELIVERED | RTO_DELIVERED_TO_SELLER | 2 |
| 7 | 19384236 | Default | I0925NC000005934 | 3/12/2024 10:21 | Nawada | Bihar | IN | 805131 | 19384236 | Nawada | Bihar | IN | 805131 | STD | ADKSET148-M | Woven Design Embroidered Thread Work Anarkali Kurta with Churidar & Dupatta | Burgandy | MYNTRAPPMP | False | 62045300.0 | 6599.0 | 4487.0 | 4487.0 | 0.0 | 6118.250 | 2112.0 | NaN | 0.000 | 480.750 | 0.000 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Woven Design Embroidered Thread Work Anarkali Kurta with Churidar & Dupatta | ADKSET148-M | DELIVERED | STATUS_NOT_DEFINED | 2 |
| 8 | 20312124 | Default | I0925NC000006798 | 18/01/2025 09:48 | Lucknow | Uttar Pradesh | IN | 226004 | 20312124 | Lucknow | Uttar Pradesh | IN | 226004 | STD | ADKSET148-L | Woven Design Embroidered Thread Work Anarkali Kurta with Churidar & Dupatta | Burgandy | MYNTRAPPMP | False | 62045300.0 | 6599.0 | 4487.0 | 4487.0 | 0.0 | 6118.250 | 2112.0 | GST12 | 240.375 | 0.000 | 240.375 | 0 | 0 | 6.0 | 0 | 6.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Woven Design Embroidered Thread Work Anarkali Kurta with Churidar & Dupatta | ADKSET148-L | COURIER_RETURN-DELIVERED | RTO_DELIVERED_TO_SELLER | 2 |
| 9 | 20900823 | Default | I0925NC000007693 | 21/02/2025 10:02 | Bhopal | Madhya Pradesh | IN | 462001 | 20900823 | Bhopal | Madhya Pradesh | IN | 462001 | STD | ADKSET148-M | Woven Design Embroidered Thread Work Anarkali Kurta with Churidar & Dupatta | Burgandy | MYNTRAPPMP | False | 62045300.0 | 6599.0 | 4487.0 | 4487.0 | 0.0 | 6118.250 | 2112.0 | NaN | 0.000 | 480.750 | 0.000 | 0 | 0 | 0.0 | 12 | 0.0 | 0 | 0 | COMPLETE | 09AAICN9819MIZL | Woven Design Embroidered Thread Work Anarkali Kurta with Churidar & Dupatta | ADKSET148-M | SHIPPED | STATUS_NOT_DEFINED | 2 |